metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA1113956" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA1113956" and tax_clade = "FCB group"

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
221800	221800	PRJNA1113956_P_NODE_10741_length_416_cov_3.731778_g10402_i0	PRJNA1113956	10741	416	3.731778	15.52419648	Flavobacteriaceae bacterium	1871037	Bacteria	Bacteria	52.8	0.04	NTclustered	gi\|1885860246\|gb\|CP046177.1\|	1871037	g10402	i0	100	0.0673076923076923	28	0	7	0	370	397	3727682	3727709	Flavobacteriaceae bacterium isolate MH-Pat-all_autometa_1-8 chromosome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae		Flavobacteriaceae bacterium
2772608	2772608	PRJNA1113956_P_NODE_21123_length_246_cov_0.890173_g20783_i0	PRJNA1113956	21123	246	0.890173	2.18982558	Prevotella jejuni	1177574	Bacteria	Bacteria	444	3.14e-120	NTclustered	gi\|2028874433\|gb\|CP072366.1\|	1177574	g20783	i0	99.187	3.7479674796748	246	2	100	0	1	246	649158	649403	Prevotella jejuni strain F0106 chromosome 2, complete sequence	blastn	922	444	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella jejuni
2772610	2772610	PRJNA1113956_P_NODE_21163_length_246_cov_0.890173_g20823_i0	PRJNA1113956	21163	246	0.890173	2.18982558	Capnocytophaga gingivalis	1017	Bacteria	Bacteria	97.1	1.01e-15	NTclustered	gi\|1242564872\|gb\|CP022386.1\|	1017	g20823	i0	90.411	0.296747967479675	73	7	30	0	27	99	1405767	1405839	Capnocytophaga gingivalis strain H1496 chromosome, complete genome	blastn	73	97.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga gingivalis
3574390	3574390	PRJNA1113956_P_NODE_22083_length_243_cov_0.905882_g21743_i0	PRJNA1113956	22083	243	0.905882	2.20129326	Elizabethkingia	308865	Bacteria	Bacteria	444	3.09e-120	NTclustered	gi\|2638023975\|gb\|CP140570.1\|	172045	g21743	i0	99.588	40.6378600823045	243	1	100	0	1	243	1558271	1558029	Elizabethkingia miricola strain 2023CK-01286 chromosome, complete genome	blastn	9875	444	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia miricola
4048906	4048906	PRJNA1113956_P_NODE_21124_length_246_cov_0.890173_g20784_i0	PRJNA1113956	21124	246	0.890173	2.18982558	Prevotella melaninogenica	28132	Bacteria	Bacteria	444	3.14e-120	NTclustered	gi\|2028866082\|gb\|CP072360.1\|	28132	g20784	i0	99.187	2	246	2	100	0	1	246	1562871	1563116	Prevotella melaninogenica strain F0091 chromosome 1, complete sequence	blastn	492	444	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
10425546	10425546	PRJNA1113956_P_NODE_21129_length_246_cov_0.890173_g20789_i0	PRJNA1113956	21129	246	0.890173	2.18982558	Prevotella jejuni	1177574	Bacteria	Bacteria	433	6.79e-117	NTclustered	gi\|2028874433\|gb\|CP072366.1\|	1177574	g20789	i0	98.374	5.04471544715447	246	4	100	0	1	246	335117	334872	Prevotella jejuni strain F0106 chromosome 2, complete sequence	blastn	1241	433	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella jejuni
11227207	11227207	PRJNA1113956_P_NODE_20449_length_249_cov_0.875000_g20109_i0	PRJNA1113956	20449	249	0.875	2.17875	Weeksellaceae	2762318	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|1966888383\|gb\|CP068486.1\|	250	g20109	i0	100	15.855421686747	249	0	100	0	1	249	21051	20803	Chryseobacterium gleum strain FDAARGOS_1103 chromosome	blastn	3948	460	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gleum
15524586	15524586	PRJNA1113956_P_NODE_21553_length_245_cov_0.895349_g21213_i0	PRJNA1113956	21553	245	0.895349	2.19360505	Prevotella melaninogenica	28132	Bacteria	Bacteria	420	5.26e-113	NTclustered	gi\|2028848006\|gb\|CP072343.1\|	28132	g21213	i0	97.551	15.4897959183673	245	6	100	0	1	245	189167	189411	Prevotella melaninogenica strain F0695 chromosome 1, complete sequence	blastn	3795	420	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
17601587	17601587	PRJNA1113956_P_NODE_22574_length_242_cov_0.911243_g22234_i0	PRJNA1113956	22574	242	0.911243	2.20520806	Chryseobacterium	59732	Bacteria	Bacteria	401	1.8799999999999994e-107	NTclustered	gi\|2631708025\|dbj\|AP029022.1\|	373672	g22234	i0	96.356	4.09090909090909	247	4	100	1	1	242	939203	939449	Chryseobacterium gambrini DW100 DNA, complete genome	blastn	990	401	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
18073607	18073607	PRJNA1113956_P_NODE_20275_length_249_cov_0.875000_g19935_i0	PRJNA1113956	20275	249	0.875	2.17875	Elizabethkingia bruuniana	1756149	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|1154492239\|gb\|CP014337.1\|	1756149	g19935	i0	100	90.0481927710843	249	0	100	0	1	249	4209374	4209126	Elizabethkingia bruuniana strain G0146 chromosome, complete genome	blastn	22422	460	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia bruuniana
19347895	19347895	PRJNA1113956_P_NODE_20576_length_248_cov_0.880000_g20236_i0	PRJNA1113956	20576	248	0.88	2.1824	Epilithonimonas vandammei	2487072	Bacteria	Bacteria	359	1.18e-94	NTclustered	gi\|1527200821\|gb\|CP034160.1\|	2487072	g20236	i0	93.089	9.22177419354839	246	16	99	1	3	248	1003137	1003381	Epilithonimonas vandammei strain H6466 chromosome, complete genome	blastn	2287	359	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Epilithonimonas	Epilithonimonas vandammei
22700801	22700801	PRJNA1113956_P_NODE_21938_length_244_cov_0.900585_g21598_i0	PRJNA1113956	21938	244	0.900585	2.1974274	Porphyromonas	836	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|1274919567\|gb\|CP024601.1\|	837	g21598	i0	100	35	244	0	100	0	1	244	594396	594153	Porphyromonas gingivalis strain KCOM 2799 chromosome, complete genome	blastn	8540	451	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae	Porphyromonas	Porphyromonas gingivalis
23174283	23174283	PRJNA1113956_P_NODE_20579_length_248_cov_0.880000_g20239_i0	PRJNA1113956	20579	248	0.88	2.1824	Prevotella melaninogenica	28132	Bacteria	Bacteria	403	5.38e-108	NTclustered	gi\|2028848006\|gb\|CP072343.1\|	28132	g20239	i0	95.968	2	248	10	100	0	1	248	1096655	1096902	Prevotella melaninogenica strain F0695 chromosome 1, complete sequence	blastn	496	403	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
23174304	23174304	PRJNA1113956_P_NODE_22499_length_242_cov_0.911243_g22159_i0	PRJNA1113956	22499	242	0.911243	2.20520806	Elizabethkingia bruuniana	1756149	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|1154492239\|gb\|CP014337.1\|	1756149	g22159	i0	100	90.6198347107438	242	0	100	0	1	242	231902	231661	Elizabethkingia bruuniana strain G0146 chromosome, complete genome	blastn	21930	448	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia bruuniana
24448111	24448111	PRJNA1113956_P_NODE_19780_length_251_cov_0.865169_g19440_i0	PRJNA1113956	19780	251	0.865169	2.17157419	Elizabethkingia bruuniana	1756149	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|1154492239\|gb\|CP014337.1\|	1756149	g19440	i0	100	32.6573705179283	251	0	100	0	1	251	3323409	3323659	Elizabethkingia bruuniana strain G0146 chromosome, complete genome	blastn	8197	464	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia bruuniana
24448120	24448120	PRJNA1113956_P_NODE_20440_length_249_cov_0.875000_g20100_i0	PRJNA1113956	20440	249	0.875	2.17875	Chryseobacterium sp. ZHDP1	2838877	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|2046786976\|gb\|CP075682.1\|	2838877	g20100	i0	100	4.96385542168675	249	0	100	0	1	249	1986979	1986731	Chryseobacterium sp. ZHDP1 chromosome, complete genome	blastn	1236	460	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. ZHDP1
24448122	24448122	PRJNA1113956_P_NODE_20720_length_248_cov_0.880000_g20380_i0	PRJNA1113956	20720	248	0.88	2.1824	Elizabethkingia bruuniana	1756149	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|1154492239\|gb\|CP014337.1\|	1756149	g20380	i0	100	18.9758064516129	248	0	100	0	1	248	3409364	3409117	Elizabethkingia bruuniana strain G0146 chromosome, complete genome	blastn	4706	459	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia bruuniana

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