metadata: contig_metadata: 5 rows where bioproject = "PRJNA509429" and tax

5 rows where bioproject = "PRJNA509429" 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
10688978	10688978	PRJNA509429_P_NODE_29869_length_225_cov_3.263158_g29041_i0	PRJNA509429	29869	225	3.263158	7.3421055	Circovirus	39725	Viruses	Viruses	62	3.84e-9	NR	UJO02094.1	2911953	g29041	i0	60	1.13333333333333	45	18	60	0	91	225	8	52	UJO02094.1 Rep [Molossus molossus associated circovirus 4]	diamond	255	62	1	Viruses	Shotokuvirae	Cressdnaviricota	Arfiviricetes	Cirlivirales	Circoviridae	Circovirus	Molossus molossus associated circovirus 4
11963993	11963993	PRJNA509429_P_NODE_39630_length_182_cov_1.938776_g38802_i0	PRJNA509429	39630	182	1.938776	3.52857232	Bee densovirus 6	3077360	Viruses	Viruses	329	6.39e-86	NTclustered	gi\|2636791789\|gb\|OR553300.1\|	3077360	g38802	i0	100	2.5989010989011	178	0	98	0	5	182	3735	3558	MAG: Bee densovirus 6 isolate BD6, complete genome	blastn	473	329	1	Viruses	Shotokuvirae	Cossaviricota	Quintoviricetes	Piccovirales	Parvoviridae		Bee densovirus 6
17062570	17062570	PRJNA509429_P_NODE_42534_length_173_cov_1.608696_g41706_i0	PRJNA509429	42534	173	1.608696	2.78304408	Betapolyomavirus macacae	1891767	Viruses	Viruses	117	5.08e-22	NTclustered	gi\|156598992\|gb\|EF579658.1\|	1891767	g41706	i0	84.426	0.705202312138728	122	16	71	1	1	122	2567	2685	Simian virus 40 isolate SV40(Ad)191, complete genome	blastn	122	117	1	Viruses	Shotokuvirae	Cossaviricota	Papovaviricetes	Sepolyvirales	Polyomaviridae	Betapolyomavirus	Betapolyomavirus macacae
24711245	24711245	PRJNA509429_P_NODE_35100_length_199_cov_3.615854_g34272_i0	PRJNA509429	35100	199	3.615854	7.19554946	Cynopterus sphinx circular DNA virus 10	3064083	Viruses	Viruses	171	4.57e-38	NTclustered	gi\|2593361801\|gb\|OQ351951.1\|	3064083	g34272	i0	97.959	0.492462311557789	98	2	49	0	8	105	2186	2283	MAG: Cynopterus sphinx circular DNA virus 10 isolate B468G10 genomic sequence	blastn	98	171	1	Viruses	Shotokuvirae	Cressdnaviricota					Cynopterus sphinx circular DNA virus 10
27235176	27235176	PRJNA509429_P_NODE_43603_length_170_cov_1.422222_g42775_i0	PRJNA509429	43603	170	1.422222	2.4177774	Avon-Heathcote Estuary associated circular virus 1	1618232	Viruses	Viruses	65.5	8.01e-11	NR	YP_009126932.1	1618232	g42775	i0	57.1	0.988235294117647	56	24	98.8	0	1	168	117	172	YP_009126932.1 replication-associated protein [Avon-Heathcote Estuary associated circular virus 1]	diamond	168	65.5	1	Viruses	Shotokuvirae	Cressdnaviricota	Arfiviricetes	Cirlivirales	Circoviridae		Avon-Heathcote Estuary associated circular virus 1

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