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

13 rows where analysis = "blastn", bioproject = "PRJNA1092581" and tax_phylum = "Verrucomicrobiota"

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
198154	198154	PRJNA1092581_P_NODE_9121_length_886_cov_2.257073_g8707_i0	PRJNA1092581	9121	886	2.257073	19.99766678	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	998	0	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g8707	i0	88.104	184.904063205418	849	89	95	12	44	886	2749514	2750356	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	163825	998	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
1470181	1470181	PRJNA1092581_P_NODE_10262_length_845_cov_6.077720_g9826_i0	PRJNA1092581	10262	845	6.07772	51.356734	Luteolibacter luteus	2728835	Bacteria	Bacteria	1435	0	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g9826	i0	97.839	284.749112426035	833	14	98	4	1	831	3804166	3804996	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	240613	1435	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
3568734	3568734	PRJNA1092581_P_NODE_29543_length_510_cov_3.627002_g29011_i0	PRJNA1092581	29543	510	3.627002	18.4977102	Chthoniobacter	295577	Bacteria	Bacteria	614	5.079999999999999e-171	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g29011	i0	89.271	225.76862745098	494	47	96	6	20	510	28395	27905	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	115142	616	0.996753246753247	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
4024807	4024807	PRJNA1092581_P_NODE_91764_length_266_cov_3.533679_g91231_i0	PRJNA1092581	91764	266	3.533679	9.39958614	Luteolibacter luteus	2728835	Bacteria	Bacteria	110	1.42e-19	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g91231	i0	88.043	20.1315789473684	92	11	35	0	15	106	3804996	3804905	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	5355	110	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
5298885	5298885	PRJNA1092581_P_NODE_124885_length_207_cov_5.253731_g124352_i0	PRJNA1092581	124885	207	5.253731	10.87522317	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	122	1.36e-23	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g124352	i0	87.619	6.2512077294686	105	13	51	0	38	142	1403611	1403715	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	1294	122	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
5299295	5299295	PRJNA1092581_P_NODE_24165_length_566_cov_2.835700_g23639_i0	PRJNA1092581	24165	566	2.8357	16.050062	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	870	0	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g23639	i0	95.43	205.498233215548	547	23	96	2	21	566	2556730	2557275	Lacunisphaera limnophila strain IG16b, complete genome	blastn	116312	870	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
9123409	9123409	PRJNA1092581_P_NODE_111648_length_237_cov_4.530488_g111115_i0	PRJNA1092581	111648	237	4.530488	10.73725656	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	281	2.49e-71	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g111115	i0	90	127.409282700422	220	18	92	4	21	237	3833600	3833382	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	30196	281	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
11676897	11676897	PRJNA1092581_P_NODE_9530_length_870_cov_19.454203_g9105_i0	PRJNA1092581	9530	870	19.454203	169.2515661	Candidatus Xiphinematobacter sp. Idaho Grape	1704307	Bacteria	Bacteria	913	0	NTclustered	gi\|939198278\|gb\|CP012665.1\|	1704307	g9105	i0	86.611	215.314942528736	844	91	95	22	17	846	15524	16359	Candidatus Xiphinematobacter sp. Idaho Grape, complete genome	blastn	187324	913	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria			Candidatus Xiphinematobacter	Candidatus Xiphinematobacter sp. Idaho Grape
14225591	14225591	PRJNA1092581_P_NODE_40392_length_430_cov_3.355742_g39859_i0	PRJNA1092581	40392	430	3.355742	14.4296906	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	418	3.549999999999999e-112	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g39859	i0	87.432	99.1162790697674	366	43	85	3	1	364	3048002	3047638	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	42620	418	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
15498650	15498650	PRJNA1092581_P_NODE_125273_length_206_cov_4.759398_g124740_i0	PRJNA1092581	125273	206	4.759398	9.80435988	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	217	6.029999999999999e-52	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g124740	i0	89.881	0.815533980582524	168	17	82	0	20	187	3778013	3778180	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	168	217	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
20597438	20597438	PRJNA1092581_P_NODE_22217_length_590_cov_6.767892_g21695_i0	PRJNA1092581	22217	590	6.767892	39.9305628	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	944	0	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g21695	i0	97.302	81.2406779661017	556	15	94	0	15	570	2557847	2557292	Lacunisphaera limnophila strain IG16b, complete genome	blastn	47932	944	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
21872710	21872710	PRJNA1092581_P_NODE_117558_length_227_cov_7.467532_g117025_i0	PRJNA1092581	117558	227	7.467532	16.95129764	Opitutus sp. VeGlc2	134634	Bacteria	Bacteria	206	1.4699999999999998e-48	NTclustered	gi\|164510706\|emb\|AJ966885.1\|	134634	g117025	i0	85.938	1.53303964757709	192	27	85	0	15	206	2542	2351	Opitutus sp. VeGlc2 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 11246	blastn	348	206	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. VeGlc2
23970507	23970507	PRJNA1092581_P_NODE_27339_length_532_cov_2.712418_g26807_i0	PRJNA1092581	27339	532	2.712418	14.43006376	Bacteria	2	Bacteria	Bacteria	678	0	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g26807	i0	89.662	224.781954887218	532	55	100	0	1	532	15986	16517	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	119584	678	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota 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);;