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

12 rows where analysis = "blastn", bioproject = "PRJNA588137" and tax_phylum = "Bacteroidota"

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
564808	564808	PRJNA588137_S_NODE_7441_length_249_cov_0.875000_g7408_i0	PRJNA588137	7441	249	0.875	2.17875	Porphyromonas pogonae	867595	Bacteria	Bacteria	165	2.77e-36	NTclustered	gi\|2665661841\|gb\|CP143258.1\|	867595	g7408	i0	84.211	5.10843373493976	171	25	68	1	77	245	307667	307497	Porphyromonas pogonae strain PP01-1 chromosome, complete genome	blastn	1272	165	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas pogonae
1840269	1840269	PRJNA588137_S_NODE_3582_length_304_cov_1.333333_g3549_i0	PRJNA588137	3582	304	1.333333	4.05333232	Bacteroidota bacterium	1898104	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2916445283\|gb\|CP170458.1\|	1898104	g3549	i0	100	1.41118421052632	30	0	10	0	45	74	231532	231503	MAG: Bacteroidota bacterium isolate tig00000052 chromosome, complete genome	blastn	429	56.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
1840294	1840294	PRJNA588137_S_NODE_6582_length_251_cov_0.865169_g6549_i0	PRJNA588137	6582	251	0.865169	2.17157419	Spirosoma rhododendri	2728024	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1835007590\|gb\|CP051677.1\|	2728024	g6549	i0	100	0.111553784860558	28	0	11	0	22	49	3975849	3975822	Spirosoma sp. CJU-R4 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma rhododendri
4392300	4392300	PRJNA588137_S_NODE_9064_length_245_cov_0.895349_g9031_i0	PRJNA588137	9064	245	0.895349	2.19360505	Capnocytophaga granulosa	45242	Bacteria	Bacteria	431	2.4299999999999996e-116	NTclustered	gi\|2831311145\|gb\|CP171122.1\|	45242	g9031	i0	98.367	2	245	4	100	0	1	245	428494	428250	Capnocytophaga granulosa strain WGS1377 chromosome, complete genome	blastn	490	431	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga granulosa
9493225	9493225	PRJNA588137_S_NODE_9008_length_245_cov_0.895349_g8975_i0	PRJNA588137	9008	245	0.895349	2.19360505	Chryseobacterium gambrini	373672	Bacteria	Bacteria	448	2.41e-121	NTclustered	gi\|2429070341\|gb\|CP115857.1\|	373672	g8975	i0	99.592	45.1102040816327	245	1	100	0	1	245	136312	136556	Chryseobacterium gambrini strain PL22-1A chromosome, complete genome	blastn	11052	448	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
12043850	12043850	PRJNA588137_S_NODE_10790_length_242_cov_0.911243_g10757_i0	PRJNA588137	10790	242	0.911243	2.20520806	Chryseobacterium taklimakanense	536441	Bacteria	Bacteria	392	1.1299999999999999e-104	NTclustered	gi\|1527179843\|gb\|CP034173.1\|	536441	g10757	i0	95.885	10.8347107438017	243	9	100	1	1	242	1447896	1448138	Chryseobacterium taklimakanense strain F9257 chromosome, complete genome	blastn	2622	392	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium taklimakanense
13892521	13892521	PRJNA588137_S_NODE_4511_length_283_cov_2.247619_g4478_i0	PRJNA588137	4511	283	2.247619	6.36076177	Flavobacterium	237	Bacteria	Bacteria	523	4.5999999999999983e-144	NTclustered	gi\|2279330881\|gb\|CP101751.1\|	2502784	g4478	i0	100	357.56890459364	283	0	100	0	1	283	718697	718415	Flavobacterium cerinum strain C1 chromosome, complete genome	blastn	101192	523	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium cerinum
16441228	16441228	PRJNA588137_S_NODE_6193_length_253_cov_1.266667_g6160_i0	PRJNA588137	6193	253	1.266667	3.20466751	Tenacibaculum	104267	Bacteria	Bacteria	191	4.66e-44	NTclustered	gi\|1231648903\|emb\|LT899436.1\|	584609	g6160	i0	80.392	87.802371541502	255	46	100	4	1	253	1535460	1535208	Tenacibaculum jejuense strain KCTC 22618(T) genome assembly, chromosome: TJEJU	blastn	22214	191	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Tenacibaculum	Tenacibaculum jejuense
17716410	17716410	PRJNA588137_S_NODE_8854_length_246_cov_0.890173_g8821_i0	PRJNA588137	8854	246	0.890173	2.18982558	Weeksellaceae	2762318	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|1966888383\|gb\|CP068486.1\|	250	g8821	i0	100	421.894308943089	246	0	100	0	1	246	167697	167452	Chryseobacterium gleum strain FDAARGOS_1103 chromosome	blastn	103786	455	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gleum
18989821	18989821	PRJNA588137_S_NODE_1735_length_385_cov_1.839744_g1702_i0	PRJNA588137	1735	385	1.839744	7.0830144	Flavobacterium	237	Bacteria	Bacteria	712	0	NTclustered	gi\|1608347023\|gb\|MK757666.1\|	239	g1702	i0	100	107.919480519481	385	0	100	0	1	385	365	749	Flavobacterium sp. strain 816OP8 16S ribosomal RNA gene, partial sequence	blastn	41549	712	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
20265021	20265021	PRJNA588137_S_NODE_7116_length_250_cov_0.870056_g7083_i0	PRJNA588137	7116	250	0.870056	2.17514	Prevotella	838	Bacteria	Bacteria	446	8.89e-121	NTclustered	gi\|2127636518\|gb\|CP085943.1\|	28132	g7083	i0	98.8	11	250	3	100	0	1	250	1119584	1119335	Prevotella melaninogenica strain FDAARGOS_1566 chromosome 2, complete sequence	blastn	2750	446	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
22241895	22241895	PRJNA588137_S_NODE_718_length_547_cov_2.447257_g686_i0	PRJNA588137	718	547	2.447257	13.38649579	Flavobacterium sp. WV_118_3	3151764	Bacteria	Bacteria	1011	0	NTclustered	gi\|2735349123\|gb\|CP156060.1\|	3151764	g686	i0	100	451.283363802559	547	0	100	0	1	547	105083	104537	Flavobacterium sp. WV_118_3 chromosome, complete genome	blastn	246852	1011	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. WV_118_3

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);;