metadata: contig_metadata: 23 rows where analysis = "blastn", bioproject = "PRJNA1050291" and tax

23 rows where analysis = "blastn", bioproject = "PRJNA1050291" 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
1450591	1450591	PRJNA1050291_P_NODE_16162_length_272_cov_1.567839_g15271_i0	PRJNA1050291	16162	272	1.567839	4.26452208	Parabacteroides distasonis	823	Bacteria	Bacteria	503	5.729999999999998e-138	NTclustered	gi\|2290784043\|gb\|CP103242.1\|	823	g15271	i0	100	36.0036764705882	272	0	100	0	1	272	5393987	5393716	Parabacteroides distasonis strain BFG-275 chromosome, complete genome	blastn	9793	503	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Parabacteroides	Parabacteroides distasonis
2286299	2286299	PRJNA1050291_P_NODE_18902_length_250_cov_0.881356_g18011_i0	PRJNA1050291	18902	250	0.881356	2.20339	Bacteroides	816	Bacteria	Bacteria	457	4.1099999999999985e-124	NTclustered	gi\|1881774737\|gb\|CP059408.1\|	2755405	g18011	i0	99.6	75.116	250	1	100	0	1	250	4042932	4043181	Bacteroides sp. CACC 737 chromosome, complete genome	blastn	18779	457	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides sp. CACC 737
3561737	3561737	PRJNA1050291_P_NODE_14463_length_292_cov_1.264840_g13572_i0	PRJNA1050291	14463	292	1.26484	3.6933328	root	1	Root_unresolved	Root_unresolved	534	2.1999999999999998e-147	NTclustered	gi\|1681035014\|dbj\|AP019724.1\|	820	g13572	i0	99.658	22.1164383561644	292	1	100	0	1	292	3792422	3792131	Bacteroides uniformis NBRC 113350 DNA, complete genome	blastn	6458	534	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides uniformis
3561770	3561770	PRJNA1050291_P_NODE_19583_length_247_cov_1.793103_g18692_i0	PRJNA1050291	19583	247	1.793103	4.42896441	Prevotella	838	Bacteria	Bacteria	455	1.4600000000000002e-123	NTclustered	gi\|2127636518\|gb\|CP085943.1\|	28132	g18692	i0	100	11.9392712550607	246	0	99	0	1	246	905096	905341	Prevotella melaninogenica strain FDAARGOS_1566 chromosome 2, complete sequence	blastn	2949	455	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
6553891	6553891	PRJNA1050291_P_NODE_16346_length_270_cov_1.583756_g15455_i0	PRJNA1050291	16346	270	1.583756	4.2761412	Parabacteroides distasonis	823	Bacteria	Bacteria	499	7.349999999999998e-137	NTclustered	gi\|2290676678\|gb\|CP103162.1\|	823	g15455	i0	100	1.98518518518519	270	0	100	0	1	270	3376278	3376547	Parabacteroides distasonis strain BFG-426 chromosome, complete genome	blastn	536	499	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Parabacteroides	Parabacteroides distasonis
9103593	9103593	PRJNA1050291_P_NODE_18888_length_250_cov_0.881356_g17997_i0	PRJNA1050291	18888	250	0.881356	2.20339	Parabacteroides distasonis	823	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|1829885364\|gb\|CP050956.1\|	823	g17997	i0	100	36.008	250	0	100	0	1	250	3452442	3452193	Parabacteroides distasonis strain FDAARGOS_615 chromosome	blastn	9002	462	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Parabacteroides	Parabacteroides distasonis
9939166	9939166	PRJNA1050291_P_NODE_15708_length_277_cov_1.470588_g14817_i0	PRJNA1050291	15708	277	1.470588	4.07352876	Prevotella	838	Bacteria	Bacteria	468	2.14e-127	NTclustered	gi\|2028880361\|gb\|CP072371.1\|	28129	g14817	i0	97.112	78.8086642599278	277	8	100	0	1	277	1066141	1066417	Prevotella denticola strain F0288 chromosome 1, complete sequence	blastn	21830	468	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella denticola
11654739	11654739	PRJNA1050291_P_NODE_6370_length_563_cov_5.044898_g5479_i0	PRJNA1050291	6370	563	5.044898	28.40277574	Elizabethkingia meningoseptica	238	Bacteria	Bacteria	62.1	9.22e-5	NTclustered	gi\|1153157339\|gb\|CP016378.1\|	238	g5479	i0	94.872	0.579040852575488	39	2	7	0	402	440	2833417	2833379	Elizabethkingia meningoseptica strain G4120 chromosome, complete genome	blastn	326	62.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia meningoseptica
12489937	12489937	PRJNA1050291_P_NODE_21050_length_242_cov_0.923077_g20159_i0	PRJNA1050291	21050	242	0.923077	2.23384634	Flavobacterium	237	Bacteria	Bacteria	183	7.41e-42	NTclustered	gi\|2206042033\|gb\|CP092832.1\|	1160795	g20159	i0	81.385	5.20247933884298	231	37	94	2	2	229	2413486	2413713	Flavobacterium sp. HJ-32-4 chromosome, complete genome	blastn	1259	183	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. HJ-32-4
12929725	12929725	PRJNA1050291_P_NODE_19711_length_247_cov_0.896552_g18820_i0	PRJNA1050291	19711	247	0.896552	2.21448344	uncultured Porphyromonadaceae bacterium	348578	Bacteria	Bacteria	368	1.95e-97	NTclustered	gi\|2729058688\|emb\|OZ006988.1\|	348578	g18820	i0	93.333	9.94331983805668	255	8	99	1	1	246	647504	647758	MAG: uncultured Porphyromonadaceae bacterium isolate 6732_HOM_VAC_contig_38_metaflye_large MAG genome assembly, chromosome: 1	blastn	2456	368	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Porphyromonadaceae		uncultured Porphyromonadaceae bacterium
14204682	14204682	PRJNA1050291_P_NODE_19412_length_248_cov_0.891429_g18521_i0	PRJNA1050291	19412	248	0.891429	2.21074392	Bacteroides fragilis	817	Bacteria	Bacteria	448	2.4499999999999996e-121	NTclustered	gi\|2290582439\|gb\|CP103096.1\|	817	g18521	i0	99.197	544.092741935484	249	1	100	1	1	248	366951	366703	Bacteroides fragilis strain BFG-634 chromosome	blastn	134935	448	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides fragilis
14204683	14204683	PRJNA1050291_P_NODE_19512_length_248_cov_0.891429_g18621_i0	PRJNA1050291	19512	248	0.891429	2.21074392	Pedobacter sp. KLB.chiD	3387402	Bacteria	Bacteria	206	1.6299999999999998e-48	NTclustered	gi\|2892772180\|gb\|CP178207.1\|	3387402	g18621	i0	86.243	1.50806451612903	189	26	76	0	58	246	618185	618373	Pedobacter sp. KLB.chiD chromosome, complete genome	blastn	374	206	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. KLB.chiD
14204687	14204687	PRJNA1050291_P_NODE_19692_length_247_cov_0.896552_g18801_i0	PRJNA1050291	19692	247	0.896552	2.21448344	Chryseobacterium manosquense	2754694	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1904998852\|gb\|CP060203.1\|	2754694	g18801	i0	100	2	247	0	100	0	1	247	91399	91153	Chryseobacterium manosquense strain Marseille-Q2069 chromosome	blastn	494	457	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium manosquense
15478940	15478940	PRJNA1050291_P_NODE_4693_length_742_cov_3.935725_g3806_i0	PRJNA1050291	4693	742	3.935725	29.2030795	Capnocytophaga gingivalis	1017	Bacteria	Bacteria	1155	0	NTclustered	gi\|1242564872\|gb\|CP022386.1\|	1017	g3806	i0	94.744	1.98921832884097	742	39	100	0	1	742	691962	692703	Capnocytophaga gingivalis strain H1496 chromosome, complete genome	blastn	1476	1155	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Capnocytophaga	Capnocytophaga gingivalis
16313462	16313462	PRJNA1050291_P_NODE_18433_length_252_cov_0.871508_g17542_i0	PRJNA1050291	18433	252	0.871508	2.19620016	Parabacteroides	375288	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|2290685194\|gb\|CP103185.1\|	823	g17542	i0	100	36	252	0	100	0	1	252	2240570	2240319	Parabacteroides distasonis strain BFG-150 chromosome, complete genome	blastn	9072	466	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Parabacteroides	Parabacteroides distasonis
16752957	16752957	PRJNA1050291_P_NODE_20854_length_243_cov_0.917647_g19963_i0	PRJNA1050291	20854	243	0.917647	2.22988221	Prevotella melaninogenica	28132	Bacteria	Bacteria	422	1.45e-113	NTclustered	gi\|2028857396\|gb\|CP072351.1\|	28132	g19963	i0	98.333	18.8888888888889	240	4	99	0	1	240	1845645	1845884	Prevotella melaninogenica strain F0300 chromosome 1, complete sequence	blastn	4590	422	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
18027826	18027826	PRJNA1050291_P_NODE_20295_length_245_cov_0.906977_g19404_i0	PRJNA1050291	20295	245	0.906977	2.22209365	Prevotella jejuni	1177574	Bacteria	Bacteria	414	2.45e-111	NTclustered	gi\|2028869951\|gb\|CP072363.1\|	1177574	g19404	i0	97.143	7.89795918367347	245	7	100	0	1	245	2044938	2044694	Prevotella jejuni strain F0697 chromosome 1, complete sequence	blastn	1935	414	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella jejuni
19301738	19301738	PRJNA1050291_P_NODE_19396_length_248_cov_0.891429_g18505_i0	PRJNA1050291	19396	248	0.891429	2.21074392	Bacteroides caccae	47678	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|1958282412\|gb\|CP068174.1\|	47678	g18505	i0	100	20	248	0	100	0	1	248	1451956	1452203	Bacteroides caccae strain FDAARGOS_1097 chromosome, complete genome	blastn	4960	459	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides caccae
21852767	21852767	PRJNA1050291_P_NODE_14138_length_296_cov_4.775785_g13247_i0	PRJNA1050291	14138	296	4.775785	14.1363236	Prevotella melaninogenica	28132	Bacteria	Bacteria	547	2.8799999999999986e-151	NTclustered	gi\|2127645162\|gb\|CP085940.1\|	28132	g13247	i0	100	17.6824324324324	296	0	100	0	1	296	1029725	1029430	Prevotella melaninogenica strain FDAARGOS_1567 chromosome 1, complete sequence	blastn	5234	547	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella melaninogenica
22687894	22687894	PRJNA1050291_P_NODE_20818_length_243_cov_0.917647_g19927_i0	PRJNA1050291	20818	243	0.917647	2.22988221	Hymenobacter	89966	Bacteria	Bacteria	350	6.94e-92	NTclustered	gi\|1844056603\|gb\|CP053538.1\|	2735321	g19927	i0	92.917	51.9341563786008	240	17	99	0	1	240	2570279	2570518	Hymenobacter taeanensis strain TS19 chromosome, complete genome	blastn	12620	350	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter taeanensis
23963485	23963485	PRJNA1050291_P_NODE_16159_length_272_cov_1.567839_g15268_i0	PRJNA1050291	16159	272	1.567839	4.26452208	Bacteroides	816	Bacteria	Bacteria	503	5.729999999999998e-138	NTclustered	gi\|1881774737\|gb\|CP059408.1\|	2755405	g15268	i0	100	14.9852941176471	272	0	100	0	1	272	2924990	2925261	Bacteroides sp. CACC 737 chromosome, complete genome	blastn	4076	503	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides sp. CACC 737
23963501	23963501	PRJNA1050291_P_NODE_18339_length_252_cov_0.871508_g17448_i0	PRJNA1050291	18339	252	0.871508	2.19620016	Bacteroides	816	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|2032868951\|gb\|CP072220.1\|	820	g17448	i0	100	51.9126984126984	252	0	100	0	1	252	1824455	1824706	Bacteroides uniformis strain CL11T00C07 chromosome, complete genome	blastn	13082	466	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides uniformis
24402144	24402144	PRJNA1050291_P_NODE_4820_length_722_cov_4.309707_g3932_i0	PRJNA1050291	4820	722	4.309707	31.11608454	Aurantibacillus circumpalustris	3036359	Bacteria	Bacteria	1088	0	NTclustered	gi\|2482055248\|gb\|CP121197.1\|	3036359	g3932	i0	94.053	296.873961218837	723	34	99	7	2	719	2012417	2013135	Aurantibacillus circumpalustris strain Swamp196 chromosome, complete genome	blastn	214343	1088	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Aurantibacillaceae	Aurantibacillus	Aurantibacillus circumpalustris

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