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

13 rows where analysis = "blastn", bioproject = "PRJNA1067370" 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
1013258	1013258	PRJNA1067370_P_NODE_3741_length_897_cov_2.245146_g3298_i0	PRJNA1067370	3741	897	2.245146	20.13895962	Opitutaceae	134623	Bacteria	Bacteria	1127	0	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g3298	i0	89.369	133.289855072464	903	87	100	8	1	897	2833490	2834389	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	119561	1127	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
1455489	1455489	PRJNA1067370_P_NODE_3162_length_964_cov_2.450056_g2744_i0	PRJNA1067370	3162	964	2.450056	23.61853984	Candidatus Xiphinematobacter sp.	1903058	Bacteria	Bacteria	987	0	NTclustered	gi\|1966854496\|gb\|CP068475.1\|	1903058	g2744	i0	87.035	140.215767634855	887	99	91	14	86	958	915855	914971	MAG: Candidatus Xiphinematobacter sp. isolate P21 chromosome, complete genome	blastn	135168	987	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria			Candidatus Xiphinematobacter	Candidatus Xiphinematobacter sp.
1455885	1455885	PRJNA1067370_P_NODE_92702_length_247_cov_1.149425_g92153_i0	PRJNA1067370	92702	247	1.149425	2.83907975	Pedosphaera parvula	1032527	Bacteria	Bacteria	167	7.64e-37	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g92153	i0	88.489	103.068825910931	139	14	55	2	111	247	305	167	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	25458	167	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
2731222	2731222	PRJNA1067370_P_NODE_20543_length_415_cov_1.216374_g19995_i0	PRJNA1067370	20543	415	1.216374	5.0479521	Pedosphaera parvula	1032527	Bacteria	Bacteria	348	4.54e-91	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g19995	i0	84.115	133.698795180723	384	36	92	14	35	415	1491	1852	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	55485	348	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
10383819	10383819	PRJNA1067370_P_NODE_107609_length_243_cov_0.905882_g107060_i0	PRJNA1067370	107609	243	0.905882	2.20129326	Termitidicoccus mucosus	1184151	Bacteria	Bacteria	202	2.0599999999999995e-47	NTclustered	gi\|2724066732\|gb\|CP109796.1\|	1184151	g107060	i0	82.008	20.4855967078189	239	41	98	2	1	238	3599604	3599367	Termitidicoccus mucosus strain TSB47 chromosome, complete genome	blastn	4978	202	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Termitidicoccus	Termitidicoccus mucosus
11659218	11659218	PRJNA1067370_P_NODE_115490_length_241_cov_0.875000_g114941_i0	PRJNA1067370	115490	241	0.875	2.10875	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	388	1.46e-103	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g114941	i0	96.203	246.551867219917	237	9	98	0	2	238	3992084	3991848	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	59419	388	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
11659730	11659730	PRJNA1067370_P_NODE_80990_length_251_cov_0.865169_g80441_i0	PRJNA1067370	80990	251	0.865169	2.17157419	Prosthecobacter dejongeii	48465	Bacteria	Bacteria	398	2.5399999999999994e-106	NTclustered	gi\|183579826\|emb\|AM905423.1\|	48465	g80441	i0	95.238	125.693227091633	252	11	100	1	1	251	1632	1381	Prosthecobacter dejongeii partial 23S rRNA gene, strain DSM12251	blastn	31549	398	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter dejongeii
16757526	16757526	PRJNA1067370_P_NODE_115274_length_241_cov_0.916667_g114725_i0	PRJNA1067370	115274	241	0.916667	2.20916747	Luteolibacter sp.	1962973	Bacteria	Bacteria	147	9.67e-31	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g114725	i0	79.621	9.10373443983402	211	38	86	5	31	238	2693584	2693376	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	2194	147	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
18032498	18032498	PRJNA1067370_P_NODE_30475_length_353_cov_1.653571_g29927_i0	PRJNA1067370	30475	353	1.653571	5.83710563	Verrucomicrobia bacterium IMCC26134	1637999	Bacteria	Bacteria	448	3.639999999999999e-121	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g29927	i0	89.518	114.178470254958	353	37	100	0	1	353	1902348	1901996	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	40305	448	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
18032764	18032764	PRJNA1067370_P_NODE_6755_length_685_cov_2.094771_g6243_i0	PRJNA1067370	6755	685	2.094771	14.34918135	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	989	0	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g6243	i0	92.701	236.211678832117	685	50	100	0	1	685	2749133	2748449	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	161805	989	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
21857910	21857910	PRJNA1067370_P_NODE_79798_length_251_cov_0.865169_g79249_i0	PRJNA1067370	79798	251	0.865169	2.17157419	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	302	2.0500000000000002e-77	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g79249	i0	89.3	41.6653386454183	243	22	96	4	1	241	2910896	2910656	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	10458	302	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
23132980	23132980	PRJNA1067370_P_NODE_17199_length_449_cov_1.630319_g16651_i0	PRJNA1067370	17199	449	1.630319	7.32013231	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	220	1.1299999999999999e-52	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g16651	i0	86.207	261.552338530067	203	28	45	0	1	203	2834372	2834574	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	117437	220	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
24406695	24406695	PRJNA1067370_P_NODE_28120_length_364_cov_3.611684_g27572_i0	PRJNA1067370	28120	364	3.611684	13.14652976	Chthoniobacter flavus	191863	Bacteria	Bacteria	372	2.3299999999999995e-98	NTclustered	gi\|183579828\|emb\|AM905425.1\|	497964	g27572	i0	86.04	89.3791208791209	351	43	96	6	13	361	153	499	Chthoniobacter flavus 23S rRNA gene, strain Ellin428	blastn	32534	372	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus

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