metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA429937" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA429937" and tax_kingdom = "Shotokuvirae"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1702145	1702145	PRJNA429937_P_NODE_72262_length_394_cov_2.783562_g50455_i0	PRJNA429937	72262	394	2.783562	10.96723428	Erythroparvovirus ungulate1	3052194	Viruses	Viruses	568	3.03e-157	NTclustered	gi\|1333742271\|gb\|MG026728.1\|	172297	g50455	i0	91.463	8.47208121827411	410	19	100	2	1	394	5169	4760	Bovine parvovirus 3 isolate ujs497 nonstructural protein and structural protein genes, complete cds	blastn	3338	568	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae	Erythroparvovirus	Erythroparvovirus ungulate1
2978244	2978244	PRJNA429937_P_NODE_87243_length_342_cov_4.313099_g64686_i0	PRJNA429937	87243	342	4.313099	14.75079858	Parvovirus macaca3116	3117124	Viruses	Viruses	52.8	0.032	NTclustered	gi\|2710391813\|tpg\|BK066549.1\|	3117124	g64686	i0	100	0.0818713450292398	28	0	8	0	1	28	1	28	MAG TPA_asm: Parvovirus macaca3116 isolate Parvo3116 genomic sequence	blastn	28	52.8	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Parvovirus macaca3116
11904458	11904458	PRJNA429937_P_NODE_116710_length_257_cov_1.342105_g94084_i0	PRJNA429937	116710	257	1.342105	3.44920985	Erythroparvovirus ungulate1	3052194	Viruses	Viruses	137	6.27e-28	NTclustered	gi\|2500352099\|ref\|NC_074970.1\|	172297	g94084	i0	100	2.81712062256809	74	0	51	0	128	201	450	377	Bovine parvovirus 3 putative non-structural protein and putative capsid protein genes, complete cds	blastn	724	137	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae	Erythroparvovirus	Erythroparvovirus ungulate1
11904831	11904831	PRJNA429937_P_NODE_156850_length_157_cov_2.390625_g134223_i0	PRJNA429937	156850	157	2.390625	3.75328125	Erythroparvovirus ungulate1	3052194	Viruses	Viruses	285	1.17e-72	NTclustered	gi\|2500352099\|ref\|NC_074970.1\|	172297	g134223	i0	99.363	7	157	1	100	0	1	157	4415	4571	Bovine parvovirus 3 putative non-structural protein and putative capsid protein genes, complete cds	blastn	1099	285	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae	Erythroparvovirus	Erythroparvovirus ungulate1
11906406	11906406	PRJNA429937_P_NODE_93850_length_321_cov_1.866438_g71260_i0	PRJNA429937	93850	321	1.866438	5.99126598	Erythroparvovirus ungulate1	3052194	Viruses	Viruses	252	2.77e-62	NTclustered	gi\|2500352099\|ref\|NC_074970.1\|	172297	g71260	i0	100	6.88785046728972	136	0	96	0	186	321	832	697	Bovine parvovirus 3 putative non-structural protein and putative capsid protein genes, complete cds	blastn	2211	252	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae	Erythroparvovirus	Erythroparvovirus ungulate1
15728225	15728225	PRJNA429937_P_NODE_10833_length_1104_cov_7.926512_g6367_i0	PRJNA429937	10833	1104	7.926512	87.50869248	Parvovirus sediment4381	3117200	Viruses	Viruses	1764	0	NTclustered	gi\|2710393885\|tpg\|BK066778.1\|	3117200	g6367	i0	96.613	1.93297101449275	1063	36	96	0	21	1083	489	1551	MAG TPA_asm: Parvovirus sediment4381 isolate Parvo4381 genomic sequence	blastn	2134	1764	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Parvovirus sediment4381
17004645	17004645	PRJNA429937_P_NODE_75254_length_382_cov_5.028329_g53150_i0	PRJNA429937	75254	382	5.028329	19.20821678	Gemykrogvirus	1985367	Viruses	Viruses	632	1.0199999999999998e-176	NTclustered	gi\|2045610848\|gb\|MW183017.1\|	1985367	g53150	i0	98.333	6.59685863874346	360	6	94	0	23	382	1734	2093	MAG: Gemykrogvirus isolate thr147gen1, complete genome	blastn	2520	632	1	Viruses	Shotokuvirae	Cressdnaviricota	Repensiviricetes	Geplafuvirales	Genomoviridae	Gemykrogvirus
19551555	19551555	PRJNA429937_P_NODE_11536_length_1073_cov_7.637931_g6779_i0	PRJNA429937	11536	1073	7.637931	81.95499963	Parvovirus macaca3116	3117124	Viruses	Viruses	54.7	0.03	NTclustered	gi\|2710391813\|tpg\|BK066549.1\|	3117124	g6779	i0	100	0.027027027027027	29	0	3	0	1	29	2	30	MAG TPA_asm: Parvovirus macaca3116 isolate Parvo3116 genomic sequence	blastn	29	54.7	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Parvovirus macaca3116
24653278	24653278	PRJNA429937_P_NODE_55720_length_469_cov_2.595455_g37014_i0	PRJNA429937	55720	469	2.595455	12.17268395	Erythroparvovirus ungulate1	3052194	Viruses	Viruses	477	6.349999999999998e-130	NTclustered	gi\|2500352099\|ref\|NC_074970.1\|	172297	g37014	i0	100	7.19829424307036	258	0	91	0	1	258	4811	5068	Bovine parvovirus 3 putative non-structural protein and putative capsid protein genes, complete cds	blastn	3376	477	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae	Erythroparvovirus	Erythroparvovirus ungulate1

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