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

23 rows where analysis = "blastn", bioproject = "PRJNA1022139" 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
1436362	1436362	PRJNA1022139_P_NODE_18502_length_323_cov_2.228000_g18397_i0	PRJNA1022139	18502	323	2.228	7.19644	Aquirufa lenticrescens	2696560	Bacteria	Bacteria	492	1.5099999999999996e-134	NTclustered	gi\|2091518249\|gb\|CP049834.1\|	2696560	g18397	i0	94.118	277.585139318885	323	19	100	0	1	323	216992	217314	Aquirufa lenticrescens strain 9H-EGSE chromosome, complete genome	blastn	89660	492	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa lenticrescens
3988212	3988212	PRJNA1022139_P_NODE_23804_length_289_cov_1.425926_g23699_i0	PRJNA1022139	23804	289	1.425926	4.12092614	Chryseobacterium gambrini	373672	Bacteria	Bacteria	468	2.24e-127	NTclustered	gi\|2429907221\|gb\|CP116008.1\|	373672	g23699	i0	95.848	15.5051903114187	289	12	100	0	1	289	3780398	3780686	Chryseobacterium gambrini strain DMF-6 chromosome, complete genome	blastn	4481	468	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
3988246	3988246	PRJNA1022139_P_NODE_29364_length_269_cov_1.571429_g29259_i0	PRJNA1022139	29364	269	1.571429	4.22714401	Candidatus Fluviicola riflensis	1798018	Bacteria	Bacteria	466	7.43e-127	NTclustered	gi\|1229046090\|gb\|CP022585.1\|	1798018	g29259	i0	97.794	392.137546468401	272	3	100	3	1	269	787115	786844	Candidatus Fluviicola riflensis chromosome, complete genome	blastn	105485	466	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Candidatus Fluviicola riflensis
5264651	5264651	PRJNA1022139_P_NODE_42825_length_241_cov_0.916667_g42720_i0	PRJNA1022139	42825	241	0.916667	2.20916747	Sphingobacterium mizutaii	1010	Bacteria	Bacteria	383	6.77e-102	NTclustered	gi\|1231743971\|emb\|LT906468.1\|	1010	g42720	i0	95.417	3.49792531120332	240	11	99	0	1	240	4399328	4399089	Sphingobacterium mizutaii strain NCTC12149 genome assembly, chromosome: 1	blastn	843	383	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium mizutaii
6106747	6106747	PRJNA1022139_P_NODE_10465_length_412_cov_2.088496_g10360_i0	PRJNA1022139	10465	412	2.088496	8.60460352	Fluviicola	332102	Bacteria	Bacteria	608	1.8699999999999995e-169	NTclustered	gi\|470488043\|ref\|NR_076848.1\|	191579	g10360	i0	93.812	328.915048543689	404	25	98	0	1	404	553	150	Fluviicola taffensis strain RW262 23S ribosomal RNA gene, complete sequence	blastn	135513	608	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis
6106768	6106768	PRJNA1022139_P_NODE_28725_length_271_cov_1.994949_g28620_i0	PRJNA1022139	28725	271	1.994949	5.40631179	Bacteroidota	976	Bacteria	Bacteria	501	2.05e-137	NTclustered	gi\|1434172548\|gb\|MH671385.1\|	239	g28620	i0	100	103.007380073801	271	0	100	0	1	271	362	632	Flavobacterium sp. strain Bacter-13 16S ribosomal RNA gene, partial sequence	blastn	27915	501	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
8656757	8656757	PRJNA1022139_P_NODE_36307_length_249_cov_0.875000_g36202_i0	PRJNA1022139	36307	249	0.875	2.17875	Pedobacter	84567	Bacteria	Bacteria	416	6.939999999999999e-112	NTclustered	gi\|1821195603\|gb\|CP049868.1\|	2714940	g36202	i0	96.787	278.453815261044	249	8	100	0	1	249	880640	880392	Pedobacter sp. HDW13 chromosome, complete genome	blastn	69335	416	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter sp. HDW13
8656771	8656771	PRJNA1022139_P_NODE_40607_length_244_cov_0.900585_g40502_i0	PRJNA1022139	40607	244	0.900585	2.1974274	Chryseobacterium	59732	Bacteria	Bacteria	425	1.1299999999999999e-114	NTclustered	gi\|2046786976\|gb\|CP075682.1\|	2838877	g40502	i0	98.347	99.655737704918	242	4	99	0	1	242	3562842	3562601	Chryseobacterium sp. ZHDP1 chromosome, complete genome	blastn	24316	425	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. ZHDP1
9089229	9089229	PRJNA1022139_P_NODE_3008_length_722_cov_2.035439_g2911_i0	PRJNA1022139	3008	722	2.035439	14.69586958	Chryseobacterium gambrini	373672	Bacteria	Bacteria	1201	0	NTclustered	gi\|2631708025\|dbj\|AP029022.1\|	373672	g2911	i0	96.68	419.774238227147	723	22	100	2	1	722	1783599	1782878	Chryseobacterium gambrini DW100 DNA, complete genome	blastn	303077	1201	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
10364927	10364927	PRJNA1022139_P_NODE_39629_length_245_cov_0.895349_g39524_i0	PRJNA1022139	39629	245	0.895349	2.19360505	Cloacibacterium normanense	237258	Bacteria	Bacteria	425	1.1299999999999999e-114	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g39524	i0	97.959	4.88163265306122	245	5	100	0	1	245	1060824	1061068	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	1196	425	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
12482439	12482439	PRJNA1022139_P_NODE_18490_length_323_cov_2.764000_g18385_i0	PRJNA1022139	18490	323	2.764	8.92772	Chryseobacterium	59732	Bacteria	Bacteria	425	1.55e-114	NTclustered	gi\|2631708025\|dbj\|AP029022.1\|	373672	g18385	i0	90.402	14.3684210526316	323	31	100	0	1	323	4329311	4328989	Chryseobacterium gambrini DW100 DNA, complete genome	blastn	4641	425	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
13756948	13756948	PRJNA1022139_P_NODE_10451_length_412_cov_3.368732_g10346_i0	PRJNA1022139	10451	412	3.368732	13.87917584	Chryseobacterium	59732	Bacteria	Bacteria	749	0	NTclustered	gi\|1586140306\|gb\|CP031676.1\|	250	g10346	i0	99.515	524.050970873786	412	1	100	1	1	412	2654763	2655173	Chryseobacterium gleum strain 110146 chromosome	blastn	215909	750	0.998666666666667	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gleum
14190228	14190228	PRJNA1022139_P_NODE_18852_length_321_cov_1.060484_g18747_i0	PRJNA1022139	18852	321	1.060484	3.40415364	Kaistella faecalis	2852098	Bacteria	Bacteria	257	5.95e-64	NTclustered	gi\|2155709714\|gb\|CP087583.1\|	2852098	g18747	i0	86.192	2.20560747663551	239	31	74	2	84	321	1336136	1335899	Kaistella faecalis strain F4 chromosome, complete genome	blastn	708	257	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Kaistella	Kaistella faecalis
14190373	14190373	PRJNA1022139_P_NODE_40672_length_244_cov_0.877193_g40567_i0	PRJNA1022139	40672	244	0.877193	2.14035092	Cytophagaceae bacterium ABcell3	3069752	Bacteria	Bacteria	58.4	4.73e-4	NTclustered	gi\|2570617343\|gb\|CP133159.1\|	3069752	g40567	i0	97.143	1.09426229508197	35	0	14	1	14	47	2392198	2392232	Cytophagaceae bacterium ABcell3	blastn	267	58.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae		Cytophagaceae bacterium ABcell3
15031341	15031341	PRJNA1022139_P_NODE_9712_length_426_cov_3.237960_g9607_i0	PRJNA1022139	9712	426	3.23796	13.7937096	Chryseobacterium	59732	Bacteria	Bacteria	771	0	NTclustered	gi\|1519580736\|gb\|CP033930.1\|	253	g9607	i0	99.527	513.866197183099	423	2	99	0	1	423	2944180	2943758	Chryseobacterium indologenes strain H5559 chromosome, complete genome	blastn	218907	771	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
17581392	17581392	PRJNA1022139_P_NODE_33754_length_252_cov_2.312849_g33649_i0	PRJNA1022139	33754	252	2.312849	5.82837948	Aquirufa	2676247	Bacteria	Bacteria	248	2.72e-61	NTclustered	gi\|2259823876\|gb\|CP049835.1\|	2516559	g33649	i0	85.774	114.18253968254	239	29	93	4	10	244	214392	214155	Aquirufa antheringensis strain 44A-TON chromosome, complete genome	blastn	28774	248	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa antheringensis
20562828	20562828	PRJNA1022139_P_NODE_29737_length_268_cov_1.220513_g29632_i0	PRJNA1022139	29737	268	1.220513	3.27097484	Hymenobacter sp. APR13	1356852	Bacteria	Bacteria	196	1.07e-45	NTclustered	gi\|670934364\|gb\|CP006587.1\|	1356852	g29632	i0	80.147	19.7574626865672	272	46	100	5	1	268	2102955	2103222	Hymenobacter sp. APR13, complete genome	blastn	5295	196	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter sp. APR13
20562873	20562873	PRJNA1022139_P_NODE_36517_length_249_cov_0.875000_g36412_i0	PRJNA1022139	36517	249	0.875	2.17875	Prevotella corporis	28128	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|2446185766\|gb\|CP118020.1\|	28128	g36412	i0	99.598	1.3574297188755	249	1	100	0	1	249	1558210	1557962	Prevotella corporis strain OB21 FMU 4 chromosome 1, complete sequence	blastn	338	455	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella corporis
21838405	21838405	PRJNA1022139_P_NODE_17638_length_330_cov_1.198444_g17533_i0	PRJNA1022139	17638	330	1.198444	3.9548652	Chryseobacterium gambrini	373672	Bacteria	Bacteria	520	7.0899999999999985e-143	NTclustered	gi\|2631708025\|dbj\|AP029022.1\|	373672	g17533	i0	95.137	9.25151515151515	329	16	99	0	2	330	4051923	4052251	Chryseobacterium gambrini DW100 DNA, complete genome	blastn	3053	520	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium gambrini
21838612	21838612	PRJNA1022139_P_NODE_42178_length_242_cov_0.911243_g42073_i0	PRJNA1022139	42178	242	0.911243	2.20520806	Sphingobacterium mizutaii	1010	Bacteria	Bacteria	403	5.22e-108	NTclustered	gi\|1231743971\|emb\|LT906468.1\|	1010	g42073	i0	96.694	2	242	8	100	0	1	242	2577527	2577768	Sphingobacterium mizutaii strain NCTC12149 genome assembly, chromosome: 1	blastn	484	403	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium mizutaii
23114045	23114045	PRJNA1022139_P_NODE_42699_length_241_cov_0.916667_g42594_i0	PRJNA1022139	42699	241	0.916667	2.20916747	Tannerella serpentiformis	712710	Bacteria	Bacteria	407	4.0199999999999995e-109	NTclustered	gi\|1379127804\|gb\|CP017038.2\|	712710	g42594	i0	97.095	2	241	7	100	0	1	241	674856	675096	Tannerella serpentiformis strain W11667 chromosome, complete genome	blastn	482	407	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Tannerella	Tannerella serpentiformis
23955934	23955934	PRJNA1022139_P_NODE_5699_length_544_cov_1.490446_g5595_i0	PRJNA1022139	5699	544	1.490446	8.10802624	Fluviicola	332102	Bacteria	Bacteria	843	0	NTclustered	gi\|470488043\|ref\|NR_076848.1\|	191579	g5595	i0	96.124	270.213235294118	516	20	95	0	29	544	1731	1216	Fluviicola taffensis strain RW262 23S ribosomal RNA gene, complete sequence	blastn	146996	843	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis
24387942	24387942	PRJNA1022139_P_NODE_9900_length_423_cov_0.997143_g9795_i0	PRJNA1022139	9900	423	0.997143	4.21791489	Bacteroides uniformis	820	Bacteria	Bacteria	52.8	0.041	NTclustered	gi\|1681035014\|dbj\|AP019724.1\|	820	g9795	i0	100	0.33096926713948	28	0	7	0	38	65	3061345	3061318	Bacteroides uniformis NBRC 113350 DNA, complete genome	blastn	140	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides uniformis

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