metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA326068" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA326068" 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
389474	389474	PRJNA326068_P_NODE_9641_length_326_cov_7.744108_g8682_i0	PRJNA326068	9641	326	7.744108	25.24579208	Rhodothermales bacterium	2306054	Bacteria	Bacteria	219	2.8599999999999993e-52	NTclustered	gi\|2518550857\|emb\|OX638318.1\|	2306054	g8682	i0	85.388	215.20245398773	219	23	66	8	1	214	1466451	1466665	MAG: Rhodothermales bacterium isolate 55cba9af-49f2-4dbc-822e-66a085d3a702 genome assembly, chromosome: 1	blastn	70156	219	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
1069221	1069221	PRJNA326068_P_NODE_9001_length_342_cov_192.936102_g8047_i0	PRJNA326068	9001	342	192.936102	659.84146884	Rubrivirga	1434037	Bacteria	Bacteria	549	9.399999999999999e-152	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g8047	i0	95.614	385.25730994152	342	15	100	0	1	342	806148	806489	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	131758	549	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
3619863	3619863	PRJNA326068_P_NODE_18863_length_166_cov_10.306569_g17900_i0	PRJNA326068	18863	166	10.306569	17.10890454	Rubrivirga	1434037	Bacteria	Bacteria	226	7.739999999999998e-55	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g17900	i0	91.463	142.963855421687	164	14	99	0	1	164	805858	805695	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	23732	226	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
3619874	3619874	PRJNA326068_P_NODE_4083_length_547_cov_11.162162_g3331_i0	PRJNA326068	4083	547	11.162162	61.05702614	Rubrivirga	1434037	Bacteria	Bacteria	647	0	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g3331	i0	88.139	118.870201096892	548	60	99	5	4	547	807015	806469	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	65022	647	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
4216726	4216726	PRJNA326068_P_NODE_19964_length_151_cov_10.729508_g19001_i0	PRJNA326068	19964	151	10.729508	16.20155708	Rhodothermales bacterium	2306054	Bacteria	Bacteria	169	1.17e-37	NTclustered	gi\|2621702557\|emb\|OY760427.1\|	2306054	g19001	i0	91.27	139.46357615894	126	8	83	2	1	125	5501643	5501766	MAG: Rhodothermales bacterium isolate 1504ddc0-b432-43e2-af37-a45191a88aeb genome assembly, chromosome: 1	blastn	21059	169	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales			Rhodothermales bacterium
5492984	5492984	PRJNA326068_P_NODE_4105_length_545_cov_12.620155_g3353_i0	PRJNA326068	4105	545	12.620155	68.77984475	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	632	1.4999999999999998e-176	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g3353	i0	87.751	97.045871559633	547	60	99	7	1	542	806471	807015	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	52890	632	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
9317468	9317468	PRJNA326068_P_NODE_4668_length_511_cov_7.304979_g3874_i0	PRJNA326068	4668	511	7.304979	37.32844269	Rubrivirga sp. IMCC45206	3391614	Bacteria	Bacteria	243	2.7700000000000002e-59	NTclustered	gi\|2890849321\|gb\|CP177357.1\|	3391614	g3874	i0	87.864	80.8982387475538	206	25	40	0	149	354	3830449	3830244	Rubrivirga sp. IMCC45206 chromosome, complete genome	blastn	41339	243	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC45206
15097028	15097028	PRJNA326068_P_NODE_16072_length_208_cov_7.178771_g15109_i0	PRJNA326068	16072	208	7.178771	14.93184368	Rubrivirga	1434037	Bacteria	Bacteria	230	7.839999999999999e-56	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g15109	i0	86.603	97.8509615384615	209	27	100	1	1	208	805858	805650	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	20353	230	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
18241087	18241087	PRJNA326068_P_NODE_7995_length_371_cov_95.371345_g7050_i0	PRJNA326068	7995	371	95.371345	353.82768995	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	477	4.909999999999999e-130	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g7050	i0	90	227.854447439353	370	36	99	1	1	370	806385	806017	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	84534	477	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
18241091	18241091	PRJNA326068_P_NODE_9315_length_334_cov_639.216393_g8360_i0	PRJNA326068	9315	334	639.216393	2134.98275262	Rubricoccaceae bacterium	2838334	Bacteria	Bacteria	405	2.0999999999999995e-108	NTclustered	gi\|2874254104\|emb\|OY970187.1\|	2838334	g8360	i0	88.822	106.044910179641	331	36	99	1	4	334	1309994	1310323	MAG: Rubricoccaceae bacterium isolate MFD03250.bin.2.52 genome assembly, chromosome: 1	blastn	35419	405	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae		Rubricoccaceae bacterium
22065906	22065906	PRJNA326068_P_NODE_9978_length_317_cov_122.524306_g9019_i0	PRJNA326068	9978	317	122.524306	388.40205002	Rubrivirga sp. IMCC43871	3391575	Bacteria	Bacteria	521	1.8799999999999999e-143	NTclustered	gi\|2890853429\|gb\|CP177355.1\|	3391575	g9019	i0	96.508	210.293375394322	315	11	99	0	3	317	806462	806148	Rubrivirga sp. IMCC43871 chromosome, complete genome	blastn	66663	521	1	Bacteria	FCB group	Pseudomonadati	Rhodothermota	Rhodothermia	Rhodothermales	Rubricoccaceae	Rubrivirga	Rubrivirga sp. IMCC43871
23341323	23341323	PRJNA326068_P_NODE_14879_length_221_cov_13.333333_g13916_i0	PRJNA326068	14879	221	13.333333	29.46666593	Rhodothermales bacterium	2306054	Bacteria	Bacteria	207	3.95e-49	NTclustered	gi\|2518550857\|emb\|OX638318.1\|	2306054	g13916	i0	84.332	623.085972850679	217	29	97	5	8	221	1466665	1466451	MAG: Rhodothermales bacterium isolate 55cba9af-49f2-4dbc-822e-66a085d3a702 genome assembly, chromosome: 1	blastn	137702	207	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);;