metadata: contig_metadata: 8 rows where bioproject = "PRJEB11523" and tax_phylum = "Candidatus Roizmaniibacteriota"

8 rows where bioproject = "PRJEB11523" and tax_phylum = "Candidatus Roizmaniibacteriota"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	analysis_used	target	taxid	gene	allele	pident	sumperc_cov	alnlen	mismatch	qcov	gapopen	qstart	qend	tstart	tend	target_title	analysis	sumalnlen	maxbits	bits_percmax	tax_superkingdom	tax_clade	tax_phylum	tax_species
19139257	19139257	PRJEB11523_P_NODE_5316_length_202_cov_4.666667_g5238_i0	PRJEB11523	5316	202	4.666667	9.42666734	Bacteria	2	Bacteria	Bacteria	64.7	1.26e-10	NR	OGK32862.1	1802046	g5238	i0	66	2.79207920792079	47	15	69.8	1	61	201	16	61	OGK32862.1 MAG: hypothetical protein A3F57_01920 [Candidatus Roizmanbacteria bacterium RIFCSPHIGHO2_12_FULL_36_11]	diamond	564	65.1	0.993855606758833	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium RIFCSPHIGHO2_12_FULL_36_11
24239642	24239642	PRJEB11523_P_NODE_3500_length_262_cov_2.610329_g3422_i0	PRJEB11523	3500	262	2.610329	6.83906198	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	427	3.4e-115	NTclustered	gi\|1958015594\|gb\|CP064967.1\|	2282149	g3422	i0	98.75	0.916030534351145	240	3	92	0	1	240	839180	838941	MAG: Candidatus Roizmanbacteria bacterium isolate Damh_18-Q3-R51-60_BAT3C.63_uni chromosome, complete genome	blastn	240	427	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium
26589246	26589246	PRJEB11523_P_NODE_801_length_672_cov_14.800963_g732_i0	PRJEB11523	801	672	14.800963	99.46247136	Candidatus Roizmanbacteria bacterium RIFCSPHIGHO2_	2282149	Bacteria	Bacteria	115	2.34e-25	NR	OGK13731.1	1802028	g732	i0	49.7	0.683035714285714	153	66	63.4	1	69	494	613	765	OGK13731.1 MAG: hypothetical protein A2861_03510 [Candidatus Roizmanbacteria bacterium RIFCSPHIGHO2_01_FULL_38_15]	diamond	459	115	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium RIFCSPHIGHO2_01_FULL_38_15
27064314	27064314	PRJEB11523_P_NODE_3862_length_245_cov_6.663265_g3784_i0	PRJEB11523	3862	245	6.663265	16.32499925	Candidatus Roizmanbacteria bacterium CG1	2282149	Bacteria	Bacteria	41.6	0.0246	NR	PJE63317.1	1974853	g3784	i0	30.1	0.893877551020408	73	45	89.4	2	1	219	29	95	PJE63317.1 MAG: hypothetical protein COU88_00160 [Candidatus Roizmanbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_39_6]	diamond	219	41.6	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium CG10_big_fil_rev_8_21_14_0_10_39_6
29117190	29117190	PRJEB11523_P_NODE_7169_length_171_cov_2.418033_g7091_i0	PRJEB11523	7169	171	2.418033	4.13483643	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	74.7	7.68e-14	NR	MEI6532490.1	2282149	g7091	i0	63.2	1	57	21	100	0	1	171	458	514	MEI6532490.1 hypothetical protein [Candidatus Roizmanbacteria bacterium]	diamond	171	74.7	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium
29558940	29558940	PRJEB11523_P_NODE_5570_length_197_cov_2.101351_g5492_i0	PRJEB11523	5570	197	2.101351	4.13966147	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	79	3.49e-15	NR	MEI6532490.1	2282149	g5492	i0	58.5	0.989847715736041	65	26	99	1	195	1	511	574	MEI6532490.1 hypothetical protein [Candidatus Roizmanbacteria bacterium]	diamond	195	79	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium
30001325	30001325	PRJEB11523_P_NODE_2051_length_380_cov_1.897281_g1973_i0	PRJEB11523	2051	380	1.897281	7.2096678	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	118	6.4000000000000005e-28	NR	MEI6532501.1	2282149	g1973	i0	50.8	0.963157894736842	122	59	95.5	1	17	379	535	656	MEI6532501.1 hypothetical protein [Candidatus Roizmanbacteria bacterium]	diamond	366	118	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium
31865788	31865788	PRJEB11523_P_NODE_4397_length_226_cov_3.638418_g4319_i0	PRJEB11523	4397	226	3.638418	8.22282468	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	118	5.870000000000001e-29	NR	MEI6532490.1	2282149	g4319	i0	72.6	0.969026548672566	73	20	96.9	0	8	226	571	643	MEI6532490.1 hypothetical protein [Candidatus Roizmanbacteria bacterium]	diamond	219	118	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;