metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA812715" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA812715" and tax_phylum = "Acidobacteriota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
813865	813865	PRJNA812715_P_NODE_59181_length_342_cov_0.881041_g57382_i0	PRJNA812715	59181	342	0.881041	3.01316022	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|2874253836\|emb\|OY969886.1\|	171953	g57382	i0	96.875	0.0935672514619883	32	1	9	0	158	189	2338574	2338543	MAG: uncultured Acidobacteriota bacterium isolate MFD10007.bin.c.1 genome assembly, chromosome: 1	blastn	32	54.7	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
2089700	2089700	PRJNA812715_P_NODE_63682_length_325_cov_2.888889_g61883_i0	PRJNA812715	63682	325	2.888889	9.38888925	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	518	2.51e-142	NTclustered	gi\|76574288\|gb\|DQ139436.1\|	171953	g61883	i0	95.652	37.3138461538462	322	14	99	0	4	325	43	364	Uncultured Acidobacteria bacterium clone CAL6 23S ribosomal RNA gene, partial sequence	blastn	12127	518	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
4642965	4642965	PRJNA812715_P_NODE_79904_length_284_cov_2.554502_g78104_i0	PRJNA812715	79904	284	2.554502	7.25478568	Terriglobus roseus	392734	Bacteria	Bacteria	505	1.67e-138	NTclustered	gi\|390410848\|gb\|CP003379.1\|	926566	g78104	i0	98.601	135.492957746479	286	2	100	1	1	284	927864	928149	Terriglobus roseus DSM 18391, complete genome	blastn	38480	505	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
5917907	5917907	PRJNA812715_P_NODE_83445_length_279_cov_1.281553_g81645_i0	PRJNA812715	83445	279	1.281553	3.57553287	uncultured Acidobacteriota bacterium	171953	Bacteria	Bacteria	422	1.6999999999999998e-113	NTclustered	gi\|76574294\|gb\|DQ139442.1\|	171953	g81645	i0	93.907	180.089605734767	279	17	100	0	1	279	1076	1354	Uncultured Acidobacteria bacterium clone CAL3 23S ribosomal RNA gene, partial sequence	blastn	50245	422	1	Bacteria	Pseudomonadati	Acidobacteriota					uncultured Acidobacteriota bacterium
9742627	9742627	PRJNA812715_P_NODE_83028_length_279_cov_3.485437_g81228_i0	PRJNA812715	83028	279	3.485437	9.72436923	Terriglobus roseus	392734	Bacteria	Bacteria	272	1.81e-68	NTclustered	gi\|390410848\|gb\|CP003379.1\|	926566	g81228	i0	100	63.2544802867383	147	0	99	0	133	279	928935	928789	Terriglobus roseus DSM 18391, complete genome	blastn	17648	272	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
11017761	11017761	PRJNA812715_P_NODE_61309_length_334_cov_1.180077_g59510_i0	PRJNA812715	61309	334	1.180077	3.94145718	Terriglobus roseus	392734	Bacteria	Bacteria	612	1.15e-170	NTclustered	gi\|390410848\|gb\|CP003379.1\|	926566	g59510	i0	99.701	106.673652694611	334	1	100	0	1	334	927044	926711	Terriglobus roseus DSM 18391, complete genome	blastn	35629	612	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
11018588	11018588	PRJNA812715_P_NODE_91189_length_266_cov_3.678756_g89388_i0	PRJNA812715	91189	266	3.678756	9.78549096	Acidobacteriota bacterium	1978231	Bacteria	Bacteria	440	4.439999999999998e-119	NTclustered	gi\|1958085512\|gb\|CP065000.1\|	1978231	g89388	i0	96.617	99.7105263157895	266	8	99	1	2	266	3299189	3298924	Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome	blastn	26523	440	1	Bacteria	Pseudomonadati	Acidobacteriota					Acidobacteriota bacterium
12294105	12294105	PRJNA812715_P_NODE_93990_length_262_cov_1.629630_g92189_i0	PRJNA812715	93990	262	1.62963	4.2696306	Terriglobus roseus	392734	Bacteria	Bacteria	479	9.249999999999999e-131	NTclustered	gi\|390410848\|gb\|CP003379.1\|	926566	g92189	i0	99.618	107.965648854962	262	1	100	0	1	262	927267	927006	Terriglobus roseus DSM 18391, complete genome	blastn	28287	479	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
16114420	16114420	PRJNA812715_P_NODE_112173_length_246_cov_0.890173_g110372_i0	PRJNA812715	112173	246	0.890173	2.18982558	Terriglobus roseus	392734	Bacteria	Bacteria	416	6.839999999999999e-112	NTclustered	gi\|559114378\|tpe\|HG526049.1\|	926566	g110372	i0	97.154	28.3170731707317	246	7	100	0	1	246	35	280	TPA: Terriglobus roseus DSM 18391 tmRNA gene Terri_roseu_18391	blastn	6966	416	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae	Terriglobus	Terriglobus roseus
19938360	19938360	PRJNA812715_P_NODE_102316_length_251_cov_0.865169_g100515_i0	PRJNA812715	102316	251	0.865169	2.17157419	Luteitalea pratensis	1855912	Bacteria	Bacteria	231	2.7199999999999997e-56	NTclustered	gi\|1016914409\|gb\|CP015136.1\|	1855912	g100515	i0	83.399	2.00796812749004	253	38	100	4	1	251	5319357	5319607	Luteitalea pratensis strain DSM 100886 chromosome, complete genome	blastn	504	231	1	Bacteria	Pseudomonadati	Acidobacteriota	Vicinamibacteria	Vicinamibacterales	Vicinamibacteraceae	Luteitalea	Luteitalea pratensis
22491426	22491426	PRJNA812715_P_NODE_85358_length_276_cov_1.231527_g83557_i0	PRJNA812715	85358	276	1.231527	3.39901452	Thermoanaerobaculum sp.	2510637	Bacteria	Bacteria	472	1.64e-128	NTclustered	gi\|2314712957\|dbj\|AP024672.1\|	2510637	g83557	i0	97.464	1.13405797101449	276	7	100	0	1	276	639755	639480	MAG: Thermoanaerobaculum sp. KatS3mg007 DNA, complete genome	blastn	313	472	1	Bacteria	Pseudomonadati	Acidobacteriota	Thermoanaerobaculia	Thermoanaerobaculales	Thermoanaerobaculaceae	Thermoanaerobaculum	Thermoanaerobaculum sp.
22491781	22491781	PRJNA812715_P_NODE_98398_length_255_cov_3.780220_g96597_i0	PRJNA812715	98398	255	3.78022	9.639561	Terriglobia bacterium	2081523	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2621703257\|emb\|OY762429.1\|	2081523	g96597	i0	100	0.219607843137255	28	0	11	0	54	81	597448	597421	MAG: Terriglobia bacterium isolate aa40cff0-ace7-4b53-8087-0ef5d3f4acaf genome assembly, chromosome: 1	blastn	56	52.8	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia				Terriglobia bacterium
22902374	22902374	PRJNA812715_P_NODE_117518_length_243_cov_0.905882_g115717_i0	PRJNA812715	117518	243	0.905882	2.20129326	Bacteria	2	Bacteria	Bacteria	414	2.4299999999999998e-111	NTclustered	gi\|2874253750\|emb\|OY969625.1\|	194844	g115717	i0	97.521	102.41975308642	242	6	99	0	2	243	1729	1970	MAG: uncultured Acidobacteriaceae bacterium isolate MFD09495.bin.1.66 genome assembly, chromosome: 1	blastn	24888	414	1	Bacteria	Pseudomonadati	Acidobacteriota	Terriglobia	Terriglobales	Acidobacteriaceae		uncultured Acidobacteriaceae bacterium

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