metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA763243" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA763243" 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
743984	743984	PRJNA763243_P_NODE_69661_length_222_cov_6.832215_g69315_i0	PRJNA763243	69661	222	6.832215	15.1675173	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	387	4.749999999999998e-103	NTclustered	gi\|544315340\|gb\|KF318250.1\|	156588	g69315	i0	99.07	95.8378378378378	215	2	97	0	4	218	414	628	Uncultured Verrucomicrobia bacterium clone ATW092 16S ribosomal RNA gene, partial sequence	blastn	21276	387	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
2019113	2019113	PRJNA763243_P_NODE_30202_length_308_cov_9.234043_g29856_i0	PRJNA763243	30202	308	9.234043	28.44085244	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	213	1.25e-50	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g29856	i0	93.706	5.96103896103896	143	8	94	1	7	148	1316393	1316251	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	1836	213	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
4571861	4571861	PRJNA763243_P_NODE_49524_length_255_cov_2.291209_g49178_i0	PRJNA763243	49524	255	2.291209	5.84258295	Akkermansia sp. N21116	3040764	Bacteria	Bacteria	322	1.6e-83	NTclustered	gi\|2634178342\|gb\|CP139035.1\|	3040764	g49178	i0	91.213	256.862745098039	239	17	93	3	14	250	790668	790904	Akkermansia sp. N21116 chromosome, complete genome	blastn	65500	322	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia sp. N21116
5847255	5847255	PRJNA763243_P_NODE_58005_length_245_cov_6.430233_g57659_i0	PRJNA763243	58005	245	6.430233	15.75407085	Luteolibacter sp.	1962973	Bacteria	Bacteria	420	5.26e-113	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g57659	i0	97.942	284.102040816327	243	3	98	1	5	245	1010010	1009768	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	69605	420	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
10948145	10948145	PRJNA763243_P_NODE_71569_length_213_cov_4.157143_g71223_i0	PRJNA763243	71569	213	4.157143	8.85471459	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	183	6.369999999999998e-42	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g71223	i0	82.71	10.0892018779343	214	29	99	8	1	210	16712	16503	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	2149	183	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
12223707	12223707	PRJNA763243_P_NODE_71290_length_214_cov_5.936170_g70944_i0	PRJNA763243	71290	214	5.93617	12.7034038	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	270	4.779999999999999e-68	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g70944	i0	99.329	119.504672897196	149	1	89	0	43	191	160	12	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	25574	270	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
14772929	14772929	PRJNA763243_P_NODE_71172_length_214_cov_28.978723_g70826_i0	PRJNA763243	71172	214	28.978723	62.01446722	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	315	2.18e-81	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g70826	i0	94.175	158.406542056075	206	12	96	0	5	210	5153088	5152883	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	33899	315	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
19869834	19869834	PRJNA763243_P_NODE_2716_length_812_cov_6.143437_g2452_i0	PRJNA763243	2716	812	6.143437	49.88470844	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	1360	0	NTclustered	gi\|164510704\|emb\|AJ966883.1\|	48466	g2452	i0	99.598	247.512315270936	746	2	99	1	1	746	4778	4034	Prosthecobacter vanneervenii 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 12252	blastn	200980	1360	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
21146216	21146216	PRJNA763243_P_NODE_557_length_1540_cov_14.133606_g453_i0	PRJNA763243	557	1540	14.133606	217.6575324	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	2806	0	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g453	i0	99.61	224.97012987013	1537	6	99	0	4	1540	279	1815	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	346454	2806	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
22420316	22420316	PRJNA763243_P_NODE_29178_length_310_cov_4.139241_g28832_i0	PRJNA763243	29178	310	4.139241	12.8316471	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	263	1.23e-65	NTclustered	gi\|294828894\|gb\|GU929353.1\|	156588	g28832	i0	99.31	90.5774193548387	145	1	95	0	4	148	188	332	Uncultured Verrucomicrobia bacterium clone 45_b6 16S ribosomal RNA gene, partial sequence	blastn	28079	263	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);;