metadata: contig_metadata: 26 rows where analysis = "blastn", bioproject = "PRJNA800090" and tax

26 rows where analysis = "blastn", bioproject = "PRJNA800090" 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
2075434	2075434	PRJNA800090_P_NODE_69662_length_409_cov_1.494118_g67477_i0	PRJNA800090	69662	409	1.494118	6.11094262	Chitinophagaceae bacterium LGM1	2837399	Bacteria	Bacteria	616	1.11e-171	NTclustered	gi\|2046997110\|gb\|CP075895.1\|	2837399	g67477	i0	93.873	281.535452322738	408	25	99	0	1	408	1076530	1076123	Chitinophagaceae bacterium LGM1 chromosome, complete genome	blastn	115148	616	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium LGM1
2495743	2495743	PRJNA800090_P_NODE_131762_length_275_cov_2.796117_g129577_i0	PRJNA800090	131762	275	2.796117	7.68932175	Chryseobacterium	59732	Bacteria	Bacteria	503	5.809999999999998e-138	NTclustered	gi\|2039848361\|gb\|CP074372.1\|	253	g129577	i0	99.636	388.025454545455	275	1	100	0	1	275	2979804	2979530	Chryseobacterium indologenes strain PgBE177 chromosome, complete genome	blastn	106707	503	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium indologenes
3347718	3347718	PRJNA800090_P_NODE_116983_length_296_cov_2.511013_g114798_i0	PRJNA800090	116983	296	2.511013	7.43259848	Candidatus Fluviicola riflensis	1798018	Bacteria	Bacteria	436	6.489999999999999e-118	NTclustered	gi\|1229046090\|gb\|CP022585.1\|	1798018	g114798	i0	93.266	347.010135135135	297	18	99	2	1	295	787223	786927	Candidatus Fluviicola riflensis chromosome, complete genome	blastn	102715	436	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Candidatus Fluviicola riflensis
3349154	3349154	PRJNA800090_P_NODE_182343_length_232_cov_0.883436_g180158_i0	PRJNA800090	182343	232	0.883436	2.04957152	Pedobacter mucosus	2895286	Bacteria	Bacteria	119	2.02e-22	NTclustered	gi\|2192693946\|gb\|CP087585.1\|	2895286	g180158	i0	85.217	1.1551724137931	115	17	50	0	42	156	3384464	3384350	Pedobacter mucosus strain Q8-18 chromosome, complete genome	blastn	268	119	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter mucosus
3771943	3771943	PRJNA800090_P_NODE_134283_length_272_cov_2.128079_g132098_i0	PRJNA800090	134283	272	2.128079	5.78837488	Fluviicola	332102	Bacteria	Bacteria	381	2.8e-101	NTclustered	gi\|1229046090\|gb\|CP022585.1\|	1798018	g132098	i0	92.193	335.665441176471	269	21	99	0	4	272	786574	786306	Candidatus Fluviicola riflensis chromosome, complete genome	blastn	91301	381	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Candidatus Fluviicola riflensis
5899942	5899942	PRJNA800090_P_NODE_104205_length_318_cov_1.417671_g102020_i0	PRJNA800090	104205	318	1.417671	4.50819378	Adhaeribacter radiodurans	2745197	Bacteria	Bacteria	130	1.3399999999999999e-25	NTclustered	gi\|1885831791\|gb\|CP055153.1\|	2745197	g102020	i0	89.32	70.3805031446541	103	11	32	0	216	318	2248861	2248759	Adhaeribacter radiodurans strain KUDC8001 chromosome, complete genome	blastn	22381	130	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Adhaeribacter	Adhaeribacter radiodurans
5900530	5900530	PRJNA800090_P_NODE_129965_length_278_cov_1.129187_g127780_i0	PRJNA800090	129965	278	1.129187	3.13913986	Flavobacterium alkalisoli	2602769	Bacteria	Bacteria	200	8.639999999999998e-47	NTclustered	gi\|1724793953\|gb\|CP042831.1\|	2602769	g127780	i0	80.072	402.125899280576	276	50	99	5	5	278	1553303	1553031	Flavobacterium alkalisoli strain XS-5 chromosome, complete genome	blastn	111791	200	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium alkalisoli
5901930	5901930	PRJNA800090_P_NODE_192785_length_228_cov_0.918239_g190600_i0	PRJNA800090	192785	228	0.918239	2.09358492	Flavobacterium johnsoniae	986	Bacteria	Bacteria	388	1.3599999999999998e-103	NTclustered	gi\|2637085106\|gb\|CP140160.1\|	376686	g190600	i0	97.368	4.98684210526316	228	6	100	0	1	228	491006	490779	Flavobacterium johnsoniae UW101 strain ATCC 17061 chromosome, complete genome	blastn	1137	388	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium johnsoniae
6324591	6324591	PRJNA800090_P_NODE_179485_length_233_cov_0.890244_g177300_i0	PRJNA800090	179485	233	0.890244	2.07426852	Bacteroidota	976	Bacteria	Bacteria	307	4.03e-79	NTclustered	gi\|2251905452\|gb\|ON738649.1\|	29529	g177300	i0	90.558	104.141630901288	233	21	99	1	1	232	1165	1397	Chitinophaga arvensicola strain PC14 16S ribosomal RNA gene, partial sequence	blastn	24265	309	0.993527508090615	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Chitinophaga	Chitinophaga arvensicola
6325111	6325111	PRJNA800090_P_NODE_59985_length_450_cov_1.721785_g57801_i0	PRJNA800090	59985	450	1.721785	7.7480325	Cytophaga	978	Bacteria	Bacteria	483	1.2999999999999995e-131	NTclustered	gi\|507148283\|ref\|NR_103089.1\|	985	g57801	i0	86.093	323.573333333333	453	57	100	6	1	450	2498	2049	Cytophaga hutchinsonii strain ATCC 33406 23S ribosomal RNA gene, complete sequence	blastn	145608	483	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Cytophaga	Cytophaga hutchinsonii
7175028	7175028	PRJNA800090_P_NODE_117386_length_296_cov_1.140969_g115201_i0	PRJNA800090	117386	296	1.140969	3.37726824	Bacteroidetes bacterium UKL13-3	1690483	Bacteria	Bacteria	370	6.68e-98	NTclustered	gi\|1012307226\|gb\|CP012155.1\|	1690483	g115201	i0	89.456	348.625	294	29	99	2	4	296	955312	955020	Bacteroidetes bacterium UKL13-3 chromosome, complete genome	blastn	103193	370	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidetes bacterium UKL13-3
7175543	7175543	PRJNA800090_P_NODE_140426_length_266_cov_1.060914_g138241_i0	PRJNA800090	140426	266	1.060914	2.82203124	Cyclobacteriaceae bacterium	2099675	Bacteria	Bacteria	255	1.73e-63	NTclustered	gi\|2556918996\|gb\|CP129487.1\|	2099675	g138241	i0	84.328	408.977443609023	268	35	99	7	3	266	2990216	2989952	MAG: Cyclobacteriaceae bacterium isolate cMAG.9 chromosome, complete genome	blastn	108788	255	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae		Cyclobacteriaceae bacterium
7175948	7175948	PRJNA800090_P_NODE_156846_length_249_cov_3.155556_g154661_i0	PRJNA800090	156846	249	3.155556	7.85733444	Flavobacterium sp. TBRC 19032	3379707	Bacteria	Bacteria	449	6.840000000000001e-122	NTclustered	gi\|2892685960\|gb\|CP174373.1\|	3379708	g154661	i0	99.197	514.730923694779	249	2	100	0	1	249	1284577	1284329	Flavobacterium sp. TBRC 19032 chromosome, complete genome	blastn	128168	449	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. TBRC 19032
8451339	8451339	PRJNA800090_P_NODE_189867_length_229_cov_0.912500_g187682_i0	PRJNA800090	189867	229	0.9125	2.089625	Flammeovirgaceae bacterium	2026740	Bacteria	Bacteria	189	1.49e-43	NTclustered	gi\|1927943223\|gb\|CP054185.1\|	2026740	g187682	i0	84.536	108.07423580786	194	26	83	4	6	196	1295436	1295628	MAG: Flammeovirgaceae bacterium isolate H1_BAC1 chromosome	blastn	24749	189	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flammeovirgaceae		Flammeovirgaceae bacterium
11003869	11003869	PRJNA800090_P_NODE_85609_length_358_cov_3.117647_g83424_i0	PRJNA800090	85609	358	3.117647	11.16117626	Blattabacterium cuenoti	1653831	Bacteria	Bacteria	267	1.11e-66	NTclustered	gi\|1893901206\|gb\|CP059195.1\|	1653831	g83424	i0	81.763	342.335195530726	329	51	91	9	1	325	354474	354797	Blattabacterium cuenoti strain NEOLAXmac chromosome	blastn	122556	267	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Blattabacteriaceae	Blattabacterium	Blattabacterium cuenoti
12277514	12277514	PRJNA800090_P_NODE_176570_length_234_cov_1.303030_g174385_i0	PRJNA800090	176570	234	1.30303	3.0490902	Elizabethkingia bruuniana	1756149	Bacteria	Bacteria	433	6.41e-117	NTclustered	gi\|1154492239\|gb\|CP014337.1\|	1756149	g174385	i0	100	89	234	0	100	0	1	234	2431930	2432163	Elizabethkingia bruuniana strain G0146 chromosome, complete genome	blastn	20826	433	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia bruuniana
12277635	12277635	PRJNA800090_P_NODE_181550_length_232_cov_1.343558_g179365_i0	PRJNA800090	181550	232	1.343558	3.11705456	uncultured Flexibacteraceae bacterium	239735	Bacteria	Bacteria	331	2.38e-86	NTclustered	gi\|41059282\|gb\|AY509376.1\|	239735	g179365	i0	98.925	87.5862068965517	186	0	80	2	47	232	1380	1197	Uncultured Flexibacteraceae bacterium clone LiUU-3-145 16S ribosomal RNA gene, partial sequence	blastn	20320	331	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae		uncultured Flexibacteraceae bacterium
16099548	16099548	PRJNA800090_P_NODE_132333_length_275_cov_1.101942_g130148_i0	PRJNA800090	132333	275	1.101942	3.0303405	Flavobacterium pectinovorum	29533	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|2548195263\|gb\|CP130042.1\|	29533	g130148	i0	100	0.101818181818182	28	0	10	0	180	207	2882074	2882047	Flavobacterium pectinovorum strain ZE23VCel01 chromosome, complete genome	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium pectinovorum
17376388	17376388	PRJNA800090_P_NODE_174354_length_235_cov_0.879518_g172169_i0	PRJNA800090	174354	235	0.879518	2.0668673	Flavobacteriales bacterium Tduv	3396570	Bacteria	Bacteria	111	3.43e-20	NTclustered	gi\|2905257666\|gb\|CP180024.1\|	3396570	g172169	i0	81.081	81.8	148	20	61	7	93	235	729040	729184	MAG: Flavobacteriales bacterium Tduv chromosome, complete genome	blastn	19223	111	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium Tduv
19072923	19072923	PRJNA800090_P_NODE_75355_length_388_cov_4.821317_g73170_i0	PRJNA800090	75355	388	4.821317	18.70670996	Chryseobacterium	59732	Bacteria	Bacteria	656	0	NTclustered	gi\|2204304890\|gb\|CP092711.1\|	2920939	g73170	i0	97.172	499.520618556701	389	10	100	1	1	388	2576869	2577257	Chryseobacterium sp. Y16C chromosome, complete genome	blastn	193814	662	0.990936555891239	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium sp. Y16C
19924294	19924294	PRJNA800090_P_NODE_153396_length_253_cov_1.190217_g151211_i0	PRJNA800090	153396	253	1.190217	3.01124901	Polaribacter marinaquae	1642819	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2713753048\|gb\|CP150496.1\|	1642819	g151211	i0	82.812	0.363636363636364	64	8	25	3	145	206	2542030	2541968	Polaribacter marinaquae strain MCCC 1K00696 chromosome, complete genome	blastn	92	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Polaribacter	Polaribacter marinaquae
21199309	21199309	PRJNA800090_P_NODE_124797_length_285_cov_1.629630_g122612_i0	PRJNA800090	124797	285	1.62963	4.6444455	Prevotella sp. GTC17262	3236797	Bacteria	Bacteria	342	1.4e-89	NTclustered	gi\|2774267536\|dbj\|AP035789.1\|	3236797	g122612	i0	88.38	273.389473684211	284	33	99	0	2	285	239272	239555	Prevotella sp. GTC17262 DNA, complete genome	blastn	77916	342	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp. GTC17262
22473608	22473608	PRJNA800090_P_NODE_108738_length_310_cov_1.195021_g106553_i0	PRJNA800090	108738	310	1.1950210000000001	3.7045651	Sphingobacteriales bacterium	2044944	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|1958049861\|gb\|CP064984.1\|	2044944	g106553	i0	94.286	0.112903225806452	35	1	11	1	115	148	531527	531561	Sphingobacteriales bacterium isolate Fred_18-Q3-R57-64_BATAC.414 chromosome	blastn	35	52.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales			Sphingobacteriales bacterium
22898901	22898901	PRJNA800090_P_NODE_82778_length_366_cov_2.259259_g80593_i0	PRJNA800090	82778	366	2.259259	8.26888794	Bacteroidota	976	Bacteria	Bacteria	231	4.16e-56	NTclustered	gi\|2634447873\|gb\|CP139724.1\|	333140	g80593	i0	78.689	371.830601092896	366	65	98	10	1	357	2112890	2112529	Roseivirga spongicola strain OXR-11 chromosome, complete genome	blastn	136090	231	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Roseivirgaceae	Roseivirga	Roseivirga spongicola
24172219	24172219	PRJNA800090_P_NODE_180679_length_232_cov_7.177914_g178494_i0	PRJNA800090	180679	232	7.177914	16.65276048	Chryseobacterium	59732	Bacteria	Bacteria	429	8.2e-116	NTclustered	gi\|1519571667\|gb\|CP033932.1\|	1241978	g178494	i0	100	509.663793103448	232	0	100	0	1	232	788630	788399	Chryseobacterium bernardetii strain G0229 chromosome, complete genome	blastn	118242	429	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium bernardetii
25446855	25446855	PRJNA800090_P_NODE_132520_length_274_cov_2.809756_g130335_i0	PRJNA800090	132520	274	2.809756	7.69873144	root	1	Root_unresolved	Root_unresolved	507	4.47e-139	NTclustered	gi\|2850837537\|gb\|PQ578042.1\|	239	g130335	i0	100	106	274	0	100	0	1	274	954	1227	Flavobacterium sp. strain TBRC 19031 16S ribosomal RNA gene, partial sequence	blastn	29044	507	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.

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