metadata: contig_metadata: 9 rows where bioproject = "PRJNA1160211" and tax

9 rows where bioproject = "PRJNA1160211" and tax_phylum = "Rhodothermota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
4866208	4866208	PRJNA1160211_S_NODE_129644_length_405_cov_9.587349_g128412_i0	PRJNA1160211	129644	405	9.587349	38.82876345	Bacteria	2	Bacteria	Bacteria	353	9.51e-93	NTclustered	gi\|2518540634\|emb\|OX638295.1\|	2306054	g128412	i0	84.182	193.923456790123	373	49	91	9	7	373	368516	368148	MAG: Rhodothermales bacterium isolate 379627e8-994f-481d-907a-dd5b185e1f88 genome assembly, chromosome: 1	blastn	78539	355	0.994366197183099	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
9967110	9967110	PRJNA1160211_S_NODE_70508_length_520_cov_9.080537_g69301_i0	PRJNA1160211	70508	520	9.080537	47.2187924	Rubrivirga	1434037	Bacteria	Bacteria	676	0	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g69301	i0	90.661	292.753846153846	514	40	98	7	9	520	807307	806800	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	152232	682	0.991202346041056	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
11241456	11241456	PRJNA1160211_S_NODE_142269_length_386_cov_2.738019_g141036_i0	PRJNA1160211	142269	386	2.738019	10.56875334	Rhodothermus	29548	Bacteria	Bacteria	388	2.47e-103	NTclustered	gi\|470485382\|ref\|NR_076698.1\|	29549	g141036	i0	87.069	496.282383419689	348	39	89	6	26	369	1584	1929	Rhodothermus marinus strain DSM 4252 23S ribosomal RNA gene, complete sequence	blastn	191565	388	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae	Rhodothermus	Rhodothermus marinus
16887477	16887477	PRJNA1160211_S_NODE_295614_length_220_cov_4.510204_g294381_i0	PRJNA1160211	295614	220	4.510204	9.9224488	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	340	3.71e-89	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g294381	i0	97.487	197.863636363636	199	5	90	0	22	220	805345	805543	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	43530	340	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
18161779	18161779	PRJNA1160211_S_NODE_264895_length_250_cov_3.508475_g263662_i0	PRJNA1160211	264895	250	3.508475	8.7711875	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	244	3.48e-60	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g263662	i0	86.818	27.14	220	27	87	2	23	240	1309157	1308938	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	6785	244	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
22715986	22715986	PRJNA1160211_S_NODE_84198_length_489_cov_7.745192_g82979_i0	PRJNA1160211	84198	489	7.745192	37.87398888	Rubrivirga	1434037	Bacteria	Bacteria	702	0	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g82979	i0	93.631	261.505112474438	471	29	96	1	1	470	805813	805343	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	127876	702	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
23262481	23262481	PRJNA1160211_S_NODE_285379_length_238_cov_3.600000_g284146_i0	PRJNA1160211	285379	238	3.6	8.568	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	278	3.24e-70	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g284146	i0	90.995	299.352941176471	211	11	86	5	12	215	806620	806411	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	71246	278	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
25265244	25265244	PRJNA1160211_S_NODE_61800_length_542_cov_28.396588_g60611_i0	PRJNA1160211	61800	542	28.396588	153.90950696	Rhodothermales	1853224	Bacteria	Bacteria	512	2.03e-140	NTclustered	gi\|1167574847\|gb\|CP020382.1\|	1779382	g60611	i0	85.265	390.546125461255	509	62	92	12	17	517	2906320	2906823	Rhodothermaceae bacterium RA chromosome, complete genome	blastn	211676	512	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rhodothermaceae		Rhodothermaceae bacterium RA
31240950	31240950	PRJNA1160211_S_NODE_28495_length_659_cov_16.648464_g27404_i0	PRJNA1160211	28495	659	16.648464	109.71337776	Rhodothermales bacterium	2306054	Bacteria	Bacteria	93.6	5.13e-18	NR	HMB91192.1	2306054	g27404	i0	42.3	0.946889226100152	104	59	46.9	1	25	333	119	222	HMB91192.1 serine protease [Rhodothermales bacterium]	diamond	624	93.6	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales 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);;