metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA929522" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA929522" 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
905337	905337	PRJNA929522_S_NODE_261_length_1120_cov_3.996180_g226_i0	PRJNA929522	261	1120	3.99618	44.757216	Candidatus Fluviicola riflensis	1798018	Bacteria	Bacteria	1735	0	NTclustered	gi\|1229046090\|gb\|CP022585.1\|	1798018	g226	i0	94.648	390.991071428571	1121	57	99	3	1	1118	787424	786304	Candidatus Fluviicola riflensis chromosome, complete genome	blastn	437910	1735	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Candidatus Fluviicola riflensis
2180728	2180728	PRJNA929522_S_NODE_3902_length_343_cov_1.918519_g3832_i0	PRJNA929522	3902	343	1.918519	6.58052017	Runella sp. SP2	2268026	Bacteria	Bacteria	518	2.66e-142	NTclustered	gi\|1509191025\|gb\|CP031030.1\|	2268026	g3832	i0	93.878	276.985422740525	343	21	100	0	1	343	5735530	5735872	Runella sp. SP2 chromosome, complete genome	blastn	95006	518	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Runella	Runella sp. SP2
2180747	2180747	PRJNA929522_S_NODE_6202_length_285_cov_1.283019_g6132_i0	PRJNA929522	6202	285	1.283019	3.65660415	Flavobacterium sp. N1719	2885633	Bacteria	Bacteria	518	2.16e-142	NTclustered	gi\|2324023522\|gb\|CP109993.1\|	2885633	g6132	i0	99.647	99.2666666666667	283	1	99	0	3	285	983853	984135	Flavobacterium sp. N1719 chromosome, complete genome	blastn	28291	518	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. N1719
2180752	2180752	PRJNA929522_S_NODE_7482_length_264_cov_1.335079_g7412_i0	PRJNA929522	7482	264	1.335079	3.52460856	Flavobacterium sp. N1719	2885633	Bacteria	Bacteria	477	3.359999999999999e-130	NTclustered	gi\|2324023522\|gb\|CP109993.1\|	2885633	g7412	i0	99.242	92.1742424242424	264	2	100	0	1	264	979980	980243	Flavobacterium sp. N1719 chromosome, complete genome	blastn	24334	477	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. N1719
3456265	3456265	PRJNA929522_S_NODE_9803_length_243_cov_0.905882_g9733_i0	PRJNA929522	9803	243	0.905882	2.20129326	Flavobacteriales bacterium	2021391	Bacteria	Bacteria	121	5.92e-23	NTclustered	gi\|2920008260\|emb\|OZ238992.1\|	2021391	g9733	i0	84.553	8.20987654320988	123	17	50	2	18	139	1696993	1697114	MAG: Flavobacteriales bacterium isolate 73eeb7d9-08c9-4a5c-b931-9a13151ceb09 genome assembly, chromosome: 1	blastn	1995	121	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium
4733758	4733758	PRJNA929522_S_NODE_1084_length_616_cov_14.110497_g371_i2	PRJNA929522	1084	616	14.110497	86.92066152	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	102	5.98e-17	NTclustered	gi\|2575820295\|emb\|OY730414.1\|	2910168	g371	i2	84.112	21.0795454545455	107	15	17	2	141	246	1273691	1273586	MAG: Longimicrobiales bacterium isolate 35361606-ee58-41ba-9638-b7483a57a1ce genome assembly, chromosome: 1	blastn	12985	102	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
4733781	4733781	PRJNA929522_S_NODE_3404_length_364_cov_1.316151_g3334_i0	PRJNA929522	3404	364	1.316151	4.79078964	Runella sp. SP2	2268026	Bacteria	Bacteria	610	4.539999999999998e-170	NTclustered	gi\|1509191025\|gb\|CP031030.1\|	2268026	g3334	i0	97.23	138.824175824176	361	8	99	2	1	360	5734298	5734657	Runella sp. SP2 chromosome, complete genome	blastn	50532	610	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Runella	Runella sp. SP2
6008614	6008614	PRJNA929522_S_NODE_9145_length_247_cov_0.885057_g9075_i0	PRJNA929522	9145	247	0.885057	2.18609079	Candidatus Azobacteroides pseudotrichonymphae	511435	Bacteria	Bacteria	84.2	7.92e-12	NTclustered	gi\|1168718596\|dbj\|AP017914.1\|	511435	g9075	i0	94.444	35.7935222672065	54	3	22	0	145	198	2650	2703	Candidatus Azobacteroides pseudotrichonymphae DNA, chromosome: II, complete genome, phylotype ProJPt-1	blastn	8841	84.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales		Candidatus Azobacteroides	Candidatus Azobacteroides pseudotrichonymphae
6357468	6357468	PRJNA929522_S_NODE_6865_length_273_cov_3.020000_g6795_i0	PRJNA929522	6865	273	3.02	8.2446	Fluviicola	332102	Bacteria	Bacteria	464	2.72e-126	NTclustered	gi\|470488043\|ref\|NR_076848.1\|	191579	g6795	i0	97.426	259.985347985348	272	7	99	0	1	272	1256	1527	Fluviicola taffensis strain RW262 23S ribosomal RNA gene, complete sequence	blastn	70976	464	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Fluviicola	Fluviicola taffensis
8558233	8558233	PRJNA929522_S_NODE_1027_length_630_cov_3.773788_g963_i0	PRJNA929522	1027	630	3.773788	23.7748644	Emticicia oligotrophica	312279	Bacteria	Bacteria	449	1.9e-121	NTclustered	gi\|387853393\|gb\|CP002961.1\|	929562	g963	i0	81.239	0.922222222222222	581	87	92	16	28	604	2761915	2761353	Emticicia oligotrophica DSM 17448, complete genome	blastn	581	449	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia oligotrophica
11108931	11108931	PRJNA929522_S_NODE_3829_length_345_cov_5.047794_g3759_i0	PRJNA929522	3829	345	5.047794	17.4148893	Polaribacter vadi	1774273	Bacteria	Bacteria	171	8.64e-38	NTclustered	gi\|2713796279\|gb\|CP150669.1\|	1774273	g3759	i0	79.457	13.0115942028986	258	39	73	12	1	251	1826276	1826526	Polaribacter vadi strain JCM 31217 chromosome, complete genome	blastn	4489	171	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Polaribacter	Polaribacter vadi
11108964	11108964	PRJNA929522_S_NODE_9389_length_245_cov_1.343023_g9319_i0	PRJNA929522	9389	245	1.343023	3.29040635	Emticicia oligotrophica	312279	Bacteria	Bacteria	316	7.099999999999998e-82	NTclustered	gi\|387853393\|gb\|CP002961.1\|	929562	g9319	i0	92	1.03265306122449	225	18	92	0	19	243	2805776	2805552	Emticicia oligotrophica DSM 17448, complete genome	blastn	253	316	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia oligotrophica
16555952	16555952	PRJNA929522_S_NODE_7273_length_267_cov_2.175258_g7203_i0	PRJNA929522	7273	267	2.175258	5.80793886	Runella	105	Bacteria	Bacteria	459	1.2299999999999998e-124	NTclustered	gi\|1430388288\|gb\|CP030850.1\|	2259595	g7203	i0	97.753	261.794007490637	267	4	100	2	1	267	4136751	4136487	Runella rosea strain HYN0085 chromosome, complete genome	blastn	69899	459	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae	Runella	Runella rosea
20031978	20031978	PRJNA929522_S_NODE_2296_length_439_cov_2.046448_g2226_i0	PRJNA929522	2296	439	2.046448	8.98390672	Aquirufa nivalisilvae	2516557	Bacteria	Bacteria	702	0	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g2226	i0	95.475	418.150341685649	442	17	100	2	1	439	361116	360675	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	183568	702	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
20379774	20379774	PRJNA929522_S_NODE_116_length_1427_cov_7.661743_g95_i0	PRJNA929522	116	1427	7.661743	109.33307261	Emticicia	312278	Bacteria	Bacteria	2206	0	NTclustered	gi\|470489174\|ref\|NR_076911.1\|	312279	g95	i0	94.608	290.08128941836	1428	71	100	6	1	1427	1444	22	Emticicia oligotrophica strain GPTSA100-15 23S ribosomal RNA gene, complete sequence	blastn	413946	2206	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia oligotrophica
20379789	20379789	PRJNA929522_S_NODE_6476_length_280_cov_1.850242_g6406_i0	PRJNA929522	6476	280	1.850242	5.1806776	Bacteroidota	976	Bacteria	Bacteria	272	1.82e-68	NTclustered	gi\|470489978\|ref\|NR_076960.1\|	995	g6406	i0	84.615	448.842857142857	286	31	99	12	1	279	846	567	Solitalea canadensis strain UASM 9D 23S ribosomal RNA gene, complete sequence	blastn	125676	272	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Solitalea	Solitalea canadensis
20379793	20379793	PRJNA929522_S_NODE_76_length_1680_cov_5.217797_g59_i0	PRJNA929522	76	1680	5.217797	87.6589896	Aquirufa	2676247	Bacteria	Bacteria	1860	0	NTclustered	gi\|1390254249\|gb\|CP029346.1\|	2516557	g59	i0	86.995	451.863095238095	1684	180	99	34	20	1680	360346	358679	Aquirufa nivalisilvae strain HME7025 chromosome, complete genome	blastn	759130	1862	0.998925886143931	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flectobacillaceae	Aquirufa	Aquirufa nivalisilvae
21307411	21307411	PRJNA929522_S_NODE_2637_length_412_cov_1.952802_g2567_i0	PRJNA929522	2637	412	1.952802	8.04554424	Lewinella sp. LCG006	3231911	Bacteria	Bacteria	279	1.67e-70	NTclustered	gi\|2773055173\|gb\|CP160680.1\|	3231911	g2567	i0	84.589	332.305825242718	292	34	70	10	97	383	792593	792878	Lewinella sp. LCG006 chromosome, complete genome	blastn	136910	279	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Lewinellaceae	Lewinella	Lewinella sp. LCG006
23857696	23857696	PRJNA929522_S_NODE_3139_length_378_cov_2.016393_g3069_i0	PRJNA929522	3139	378	2.016393	7.62196554	Flavobacterium sp. N1719	2885633	Bacteria	Bacteria	688	0	NTclustered	gi\|2324023522\|gb\|CP109993.1\|	2885633	g3069	i0	99.471	66.2962962962963	378	2	100	0	1	378	983485	983862	Flavobacterium sp. N1719 chromosome, complete genome	blastn	25060	688	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. N1719
23857726	23857726	PRJNA929522_S_NODE_8459_length_251_cov_1.134831_g8389_i0	PRJNA929522	8459	251	1.134831	2.84842581	Flavobacterium sp. N1719	2885633	Bacteria	Bacteria	364	2.57e-96	NTclustered	gi\|2324023522\|gb\|CP109993.1\|	2885633	g8389	i0	92.829	1	251	18	100	0	1	251	1015231	1015481	Flavobacterium sp. N1719 chromosome, complete genome	blastn	251	364	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. N1719

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