metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA1159911" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA1159911" and tax_clade = "PVC 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
5411891	5411891	PRJNA1159911_P_NODE_94745_length_245_cov_1.645349_g94203_i0	PRJNA1159911	94745	245	1.645349	4.03110505	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	375	1.16e-99	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g94203	i0	94.286	5.24897959183673	245	14	100	0	1	245	5464731	5464487	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	1286	375	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
13062570	13062570	PRJNA1159911_P_NODE_99711_length_242_cov_0.911243_g99169_i0	PRJNA1159911	99711	242	0.911243	2.20520806	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	255	1.55e-63	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g99169	i0	86.9	1.76446280991736	229	28	94	2	1	228	4233121	4232894	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	427	255	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
15610902	15610902	PRJNA1159911_P_NODE_593_length_5362_cov_5.504821_g572_i0	PRJNA1159911	593	5362	5.504821	295.16850202	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	896	0	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g572	i0	83.738	19.5701230883998	947	154	18	0	4042	4988	5173835	5174781	Tautonia plasticadhaerens strain ElP chromosome	blastn	104935	896	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
19434825	19434825	PRJNA1159911_P_NODE_94136_length_246_cov_0.890173_g93594_i0	PRJNA1159911	94136	246	0.890173	2.18982558	Humisphaera borealis	2807512	Bacteria	Bacteria	198	2.7e-46	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g93594	i0	86.74	5.95528455284553	181	21	73	2	56	235	5064176	5064354	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	1465	198	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
21985440	21985440	PRJNA1159911_P_NODE_87358_length_251_cov_0.865169_g86816_i0	PRJNA1159911	87358	251	0.865169	2.17157419	Urbifossiella limnaea	2528023	Bacteria	Bacteria	436	5.369999999999999e-118	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g86816	i0	98.008	57.4342629482072	251	5	100	0	1	251	2019585	2019835	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	14416	436	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
23260830	23260830	PRJNA1159911_P_NODE_85559_length_253_cov_1.305556_g85017_i0	PRJNA1159911	85559	253	1.305556	3.30305668	Singulisphaera sp. Ch08	3120278	Bacteria	Bacteria	78.7	3.79e-10	NTclustered	gi\|2732846650\|gb\|CP155447.1\|	3120278	g85017	i0	74.872	0.770750988142292	195	38	75	8	1	190	5268404	5268216	Singulisphaera sp. Ch08 chromosome, complete genome	blastn	195	78.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. Ch08
24534893	24534893	PRJNA1159911_P_NODE_99380_length_242_cov_0.911243_g98838_i0	PRJNA1159911	99380	242	0.911243	2.20520806	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	292	1.18e-74	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g98838	i0	91.204	18.1611570247934	216	17	89	2	28	242	554688	554902	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	4395	292	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368

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