metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA825466" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA825466" 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
820401	820401	PRJNA825466_P_NODE_12821_length_270_cov_2.111675_g12720_i0	PRJNA825466	12821	270	2.111675	5.7015225	Aquirufa lenticrescens	2696560	Bacteria	Bacteria	390	4.6199999999999997e-104	NTclustered	gi\|2091518249\|gb\|CP049834.1\|	2696560	g12720	i0	92.989	376.255555555556	271	14	100	2	1	270	217163	217429	Aquirufa lenticrescens strain 9H-EGSE chromosome, complete genome	blastn	101589	390	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa lenticrescens
4648845	4648845	PRJNA825466_P_NODE_29244_length_241_cov_0.880952_g29143_i0	PRJNA825466	29244	241	0.880952	2.12309432	Hymenobacter aerilatus	2932251	Bacteria	Bacteria	128	3.4999999999999997e-25	NTclustered	gi\|2221943441\|gb\|CP095053.1\|	2932251	g29143	i0	81.366	1.50622406639004	161	26	66	3	83	241	3175919	3176077	Hymenobacter aerilatus strain 5413 J-13 chromosome, complete genome	blastn	363	128	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter aerilatus
5056211	5056211	PRJNA825466_P_NODE_7684_length_310_cov_17.109705_g7583_i0	PRJNA825466	7684	310	17.109705	53.040085500000004	Bacteroides	816	Bacteria	Bacteria	473	5.219999999999998e-129	NTclustered	gi\|2049077952\|gb\|MZ350212.1\|	29523	g7583	i0	94.932	104.08064516129	296	11	95	1	8	303	779	488	Bacteroides sp. strain Y3-F-103 16S ribosomal RNA gene, partial sequence	blastn	32265	473	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides sp.
7606194	7606194	PRJNA825466_P_NODE_7986_length_307_cov_4.948718_g7885_i0	PRJNA825466	7986	307	4.948718	15.19256426	root	1	Root_unresolved	Root_unresolved	490	5.12e-134	NTclustered	gi\|2792017326\|gb\|PQ225776.1\|	46503	g7885	i0	96	97.7198697068404	300	6	98	1	6	305	749	456	Parabacteroides merdae strain C1-BN-9-176 16S ribosomal RNA gene, partial sequence	blastn	30000	490	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Parabacteroides	Parabacteroides merdae
8473307	8473307	PRJNA825466_P_NODE_1327_length_600_cov_2.825427_g1231_i0	PRJNA825466	1327	600	2.825427	16.952562	Cloacibacterium caeni	2004710	Bacteria	Bacteria	1107	0	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g1231	i0	100	469.225	599	0	99	0	2	600	1872242	1872840	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	281535	1107	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
8881229	8881229	PRJNA825466_P_NODE_7587_length_311_cov_28.331933_g7486_i0	PRJNA825466	7587	311	28.331933	88.11231163	root	1	Root_unresolved	Root_unresolved	475	1.4599999999999995e-129	NTclustered	gi\|339646182\|gb\|JN038556.1\|	823	g7486	i0	95.286	129.881028938907	297	9	95	1	8	304	333	624	Parabacteroides distasonis strain SLPYG-3 16S ribosomal RNA gene, partial sequence	blastn	40393	475	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Parabacteroides	Parabacteroides distasonis
10156689	10156689	PRJNA825466_P_NODE_7588_length_311_cov_25.079832_g7487_i0	PRJNA825466	7588	311	25.079832	77.99827752	root	1	Root_unresolved	Root_unresolved	481	3.129999999999999e-131	NTclustered	gi\|1949526629\|gb\|MW397831.1\|	820	g7487	i0	95.623	95.5144694533762	297	8	95	1	8	304	430	721	Bacteroides uniformis strain PC229 16S ribosomal RNA gene, partial sequence	blastn	29705	483	0.995859213250518	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides uniformis
13573990	13573990	PRJNA825466_P_NODE_22591_length_246_cov_0.890173_g22490_i0	PRJNA825466	22591	246	0.890173	2.18982558	Cloacibacterium caeni	2004710	Bacteria	Bacteria	436	5.25e-118	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g22490	i0	98.776	4.9390243902439	245	3	99	0	1	245	2194040	2194284	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	1215	436	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
13981961	13981961	PRJNA825466_P_NODE_2371_length_464_cov_1.887468_g2270_i0	PRJNA825466	2371	464	1.887468	8.7578515199999991	Aquirufa	2676247	Bacteria	Bacteria	503	1.04e-137	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g2270	i0	87.472	118.612068965517	447	43	95	13	8	446	359905	360346	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	55036	508	0.990157480314961	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
15256184	15256184	PRJNA825466_P_NODE_3492_length_400_cov_2.385321_g3391_i0	PRJNA825466	3492	400	2.385321	9.541284	Elizabethkingia	308865	Bacteria	Bacteria	656	0	NTclustered	gi\|1878278177\|gb\|MT793210.1\|	238	g3391	i0	96.25	121.0025	400	15	100	0	1	400	486	87	Elizabethkingia meningoseptica strain EM18 16S ribosomal RNA gene, partial sequence	blastn	48401	656	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia meningoseptica
16123020	16123020	PRJNA825466_P_NODE_1953_length_503_cov_2.423256_g1853_i0	PRJNA825466	1953	503	2.423256	12.18897768	Aureibacter tunicatorum	866807	Bacteria	Bacteria	438	3.229999999999999e-118	NTclustered	gi\|2581931629\|dbj\|AP025313.1\|	866807	g1853	i0	83	427.558648111332	500	70	98	15	1	492	5766	6258	Aureibacter tunicatorum NBRC 107587 plasmid pATrrn DNA, complete genome	blastn	215062	438	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Persicobacteraceae	Aureibacter	Aureibacter tunicatorum
16123042	16123042	PRJNA825466_P_NODE_27873_length_242_cov_0.911243_g27772_i0	PRJNA825466	27873	242	0.911243	2.20520806	Sphingobacterium sp. G1-14	2003121	Bacteria	Bacteria	448	2.3799999999999995e-121	NTclustered	gi\|1207396639\|gb\|CP021381.1\|	2003121	g27772	i0	100	50.2272727272727	242	0	100	0	1	242	4561098	4561339	Sphingobacterium sp. G1-14, complete genome	blastn	12155	448	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium sp. G1-14
17805658	17805658	PRJNA825466_P_NODE_10514_length_284_cov_2.199052_g10413_i0	PRJNA825466	10514	284	2.199052	6.24530768	Flavobacterium	237	Bacteria	Bacteria	525	1.2899999999999994e-144	NTclustered	gi\|1205046735\|gb\|MF289246.1\|	239	g10413	i0	100	107.007042253521	284	0	100	0	1	284	122	405	Flavobacterium sp. strain MMS16-G14 16S ribosomal RNA gene, partial sequence	blastn	30390	525	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
18671745	18671745	PRJNA825466_P_NODE_16835_length_251_cov_0.865169_g16734_i0	PRJNA825466	16835	251	0.865169	2.17157419	Cloacibacterium caeni	2004710	Bacteria	Bacteria	364	2.57e-96	NTclustered	gi\|2040340748\|emb\|OU015321.1\|	2004710	g16734	i0	92.829	12.6414342629482	251	18	100	0	1	251	2069563	2069313	Cloacibacterium caeni isolate Isolate2 genome assembly, chromosome: 1	blastn	3173	364	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium caeni
21222491	21222491	PRJNA825466_P_NODE_27057_length_242_cov_0.911243_g26956_i0	PRJNA825466	27057	242	0.911243	2.20520806	Flavobacterium inviolabile	2748320	Bacteria	Bacteria	414	2.41e-111	NTclustered	gi\|1865045764\|gb\|CP058278.1\|	2748320	g26956	i0	97.521	19.2396694214876	242	6	100	0	1	242	146809	147050	Flavobacterium inviolabile strain P2-65 chromosome, complete genome	blastn	4656	414	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium inviolabile
21222510	21222510	PRJNA825466_P_NODE_5757_length_338_cov_1.162264_g5656_i0	PRJNA825466	5757	338	1.162264	3.92845232	Vaginella massiliensis	1816680	Bacteria	Bacteria	569	7.119999999999998e-158	NTclustered	gi\|2831277486\|gb\|CP171010.1\|	1816680	g5656	i0	97.041	382.159763313609	338	10	100	0	1	338	495461	495124	Vaginella massiliensis strain WGS2087 chromosome, complete genome	blastn	129170	569	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Vaginella	Vaginella massiliensis
24179765	24179765	PRJNA825466_P_NODE_10139_length_287_cov_1.724299_g10038_i0	PRJNA825466	10139	287	1.724299	4.94873813	Cloacibacterium	501783	Bacteria	Bacteria	531	2.799999999999999e-146	NTclustered	gi\|1527207946\|gb\|CP034157.1\|	237258	g10038	i0	100	476.379790940767	287	0	100	0	1	287	130237	129951	Cloacibacterium normanense strain NRS-1 chromosome, complete genome	blastn	136721	531	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Cloacibacterium	Cloacibacterium normanense
24179800	24179800	PRJNA825466_P_NODE_7419_length_313_cov_69.525000_g7318_i0	PRJNA825466	7419	313	69.525	217.61325	root	1	Root_unresolved	Root_unresolved	462	1.14e-125	NTclustered	gi\|1949526568\|gb\|MW397770.1\|	818	g7318	i0	94.314	100.303514376997	299	12	96	1	10	308	644	351	Bacteroides thetaiotaomicron strain PC151 16S ribosomal RNA gene, partial sequence	blastn	31395	462	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides thetaiotaomicron
25046721	25046721	PRJNA825466_P_NODE_15340_length_256_cov_1.300546_g15239_i0	PRJNA825466	15340	256	1.300546	3.32939776	Pedobacter suwonensis	332999	Bacteria	Bacteria	255	1.65e-63	NTclustered	gi\|1717444187\|gb\|CP031708.1\|	332999	g15239	i0	95.625	1.25	160	6	63	1	1	160	4329017	4328859	Pedobacter suwonensis strain Fj_001 chromosome, complete genome	blastn	320	255	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter suwonensis
25046732	25046732	PRJNA825466_P_NODE_18500_length_249_cov_1.738636_g18399_i0	PRJNA825466	18500	249	1.738636	4.32920364	Mucilaginibacter mali	2740462	Bacteria	Bacteria	108	4.74e-19	NTclustered	gi\|1850321202\|gb\|CP054139.1\|	2740462	g18399	i0	86.408	2.91967871485944	103	8	39	5	141	238	4004886	4004987	Mucilaginibacter mali strain G2-14 chromosome, complete genome	blastn	727	108	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter mali
25454751	25454751	PRJNA825466_P_NODE_2280_length_472_cov_3.852130_g2180_i0	PRJNA825466	2280	472	3.85213	18.1820536	root	1	Root_unresolved	Root_unresolved	475	2.3e-129	NTclustered	gi\|444304111\|ref\|NR_074535.1\|	28118	g2180	i0	95.286	97.0889830508475	297	9	63	1	8	304	503	794	Odoribacter splanchnicus strain DSM 220712 16S ribosomal RNA, partial sequence	blastn	45826	475	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Odoribacteraceae	Odoribacter	Odoribacter splanchnicus

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