metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA529224" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA529224" 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
498018	498018	PRJNA529224_S_NODE_761_length_229_cov_6.725000_g754_i0	PRJNA529224	761	229	6.725	15.40025	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	424	3.76e-114	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g754	i0	100	86.3144104803494	229	0	100	0	1	229	3097108	3096880	Pirellula sp. SH-Sr6A, complete genome	blastn	19766	424	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
1773173	1773173	PRJNA529224_S_NODE_22_length_663_cov_700.031546_g18_i0	PRJNA529224	22	663	700.031546	4641.20914998	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	1122	0	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g18	i0	97.277	174.601809954751	661	18	99	0	3	663	1405536	1406196	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	115761	1122	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
4324919	4324919	PRJNA529224_S_NODE_1804_length_156_cov_5.480315_g1797_i0	PRJNA529224	1804	156	5.480315	8.5492914	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	233	4.2799999999999995e-57	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g1797	i0	93.631	206.916666666667	157	9	100	1	1	156	1868738	1868582	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	32279	233	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
5601788	5601788	PRJNA529224_S_NODE_345_length_315_cov_66.335664_g338_i0	PRJNA529224	345	315	66.335664	208.9573416	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	383	9.21e-102	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g338	i0	90.169	60.615873015873	295	27	93	2	1	294	1404113	1403820	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	19094	383	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
8151008	8151008	PRJNA529224_S_NODE_7_length_968_cov_37.823216_g3_i1	PRJNA529224	7	968	37.823216	366.12873088	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	1504	0	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g3	i1	94.753	114.667355371901	972	41	100	8	1	968	1403939	1404904	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	110998	1504	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
9426220	9426220	PRJNA529224_S_NODE_1808_length_156_cov_4.527559_g1801_i0	PRJNA529224	1808	156	4.527559	7.06299204	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	289	9e-74	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g1801	i0	100	20.4230769230769	156	0	100	0	1	156	3096609	3096454	Pirellula sp. SH-Sr6A, complete genome	blastn	3186	289	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
9426238	9426238	PRJNA529224_S_NODE_8_length_879_cov_25.443529_g3_i2	PRJNA529224	8	879	25.443529	223.64861991	Termitidicoccus mucosus	1184151	Bacteria	Bacteria	1182	0	NTclustered	gi\|2724066732\|gb\|CP109796.1\|	1184151	g3	i2	91.053	120.130830489192	883	67	99	9	3	878	5638086	5637209	Termitidicoccus mucosus strain TSB47 chromosome, complete genome	blastn	105595	1182	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Termitidicoccus	Termitidicoccus mucosus
10043029	10043029	PRJNA529224_S_NODE_28_length_627_cov_31.382943_g3_i3	PRJNA529224	28	627	31.382943	196.77105261	Verrucomicrobiota	74201	Bacteria	Bacteria	1002	0	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g3	i3	95.534	108.133971291866	627	27	99	1	2	627	5152986	5153612	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	67800	1002	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
10702008	10702008	PRJNA529224_S_NODE_49_length_540_cov_49.870841_g44_i0	PRJNA529224	49	540	49.870841	269.3025414	Saltatorellus ferox	2528018	Bacteria	Bacteria	414	5.88e-111	NTclustered	gi\|1712682957\|gb\|CP036434.1\|	2528018	g44	i0	80.776	395.037037037037	541	95	99	8	4	540	2930713	2931248	Planctomycetes bacterium Poly30 chromosome, complete genome	blastn	213320	414	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Saltatorellus	Saltatorellus ferox
11976749	11976749	PRJNA529224_S_NODE_470_length_281_cov_31.511905_g463_i0	PRJNA529224	470	281	31.511905	88.54845305	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	324	4.97e-84	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g463	i0	87.544	89.4519572953737	281	33	99	2	2	281	1403834	1404113	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	25136	324	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
13868266	13868266	PRJNA529224_S_NODE_1131_length_196_cov_5.173653_g1124_i0	PRJNA529224	1131	196	5.173653	10.14035988	Planctomycetia	203683	Bacteria	Bacteria	305	1.18e-78	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g1124	i0	96.237	90.3571428571429	186	7	95	0	8	193	122783	122968	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	17710	305	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
15142603	15142603	PRJNA529224_S_NODE_912_length_214_cov_8.081081_g905_i0	PRJNA529224	912	214	8.081081	17.29351334	Isosphaera	127	Bacteria	Bacteria	263	8.000000000000002e-66	NTclustered	gi\|470487262\|ref\|NR_076810.1\|	128	g905	i0	88.837	36.9626168224299	215	23	100	1	1	214	1320	1106	Isosphaera pallida strain IS1B 23S ribosomal RNA gene, complete sequence	blastn	7910	263	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Isosphaera	Isosphaera pallida
15800628	15800628	PRJNA529224_S_NODE_593_length_253_cov_29.928571_g586_i0	PRJNA529224	593	253	29.928571	75.71928463	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	357	4.34e-94	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g586	i0	92.4	60.4901185770751	250	19	99	0	1	250	1403835	1403586	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	15304	357	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
19624006	19624006	PRJNA529224_S_NODE_416_length_295_cov_14.150376_g409_i0	PRJNA529224	416	295	14.150376	41.7436092	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	163	1.21e-35	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g409	i0	84.706	39.0610169491525	170	18	56	7	1	165	1867830	1867664	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	11523	163	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
20900142	20900142	PRJNA529224_S_NODE_457_length_284_cov_1674.466667_g450_i0	PRJNA529224	457	284	1674.466667	4755.48533428	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	385	2.28e-102	NTclustered	gi\|2518556548\|emb\|OX638380.1\|	412056	g450	i0	92.251	224.964788732394	271	21	95	0	1	271	3921400	3921130	MAG: uncultured Verrucomicrobiae bacterium isolate efd5e50e-5b6a-4a0f-a0a2-e496bae301b3 genome assembly, chromosome: 1	blastn	63890	385	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
21516432	21516432	PRJNA529224_S_NODE_1157_length_194_cov_6.642424_g1150_i0	PRJNA529224	1157	194	6.642424	12.88630256	Isosphaera	127	Bacteria	Bacteria	246	7.159999999999999e-61	NTclustered	gi\|470487262\|ref\|NR_076810.1\|	128	g1150	i0	90.811	118.840206185567	185	16	95	1	2	185	567	383	Isosphaera pallida strain IS1B 23S ribosomal RNA gene, complete sequence	blastn	23055	246	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Isosphaera	Isosphaera pallida
21516461	21516461	PRJNA529224_S_NODE_597_length_252_cov_147.524664_g590_i0	PRJNA529224	597	252	147.524664	371.76215328	Opitutaceae	134623	Bacteria	Bacteria	442	1.1599999999999995e-119	NTclustered	gi\|1933068931\|gb\|MW261879.1\|	1913982	g590	i0	98.406	99.6071428571429	251	4	99	0	2	252	283	533	Opitutus sp. strain IMCC34717 16S ribosomal RNA gene, partial sequence	blastn	25101	442	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp.
22791609	22791609	PRJNA529224_S_NODE_258_length_351_cov_307.083851_g251_i0	PRJNA529224	258	351	307.083851	1077.86431701	Opitutaceae	134623	Bacteria	Bacteria	527	4.519999999999999e-145	NTclustered	gi\|336181172\|gb\|JF922312.1\|	1045324	g251	i0	96.285	97.6210826210826	323	8	91	4	30	350	1	321	Opitutus sp. WS3(2011) 16S ribosomal RNA gene, partial sequence	blastn	34265	527	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. WS3(2011)

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