metadata: contig_metadata: 5 rows where bioproject = "PRJNA293022", tax_phylum = "Kitrinoviricota" and tax

5 rows where bioproject = "PRJNA293022", tax_phylum = "Kitrinoviricota" and tax_superkingdom = "Viruses"

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
6750912	6750912	PRJNA293022_P_NODE_31006_length_252_cov_0.935961_g30269_i0	PRJNA293022	31006	252	0.935961	2.35862172	Tobamovirus rehmanniae	3432888	Viruses	Viruses	429	9.04e-116	NTclustered	gi\|354721027\|dbj\|AB628188.1\|	425279	g30269	i0	97.6	95.1507936507936	250	6	99	0	1	250	4009	3760	Rehmannia mosaic virus genomic RNA, complete genome, isolate: Japanese	blastn	23978	429	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Virgaviridae	Tobamovirus	Tobamovirus rehmanniae
11851955	11851955	PRJNA293022_P_NODE_42790_length_213_cov_2.542683_g42053_i0	PRJNA293022	42790	213	2.542683	5.41591479	Chrocorelt virus	3129514	Viruses	Viruses	283	6.109999999999999e-72	NTclustered	gi\|2717317772\|gb\|PP171962.1\|	3129514	g42053	i0	91.346	128.981220657277	208	16	98	1	6	213	2475	2680	MAG: Chrocorelt virus isolate CC1B_k141_7916 genomic sequence	blastn	27473	283	1	Viruses	Orthornavirae	Kitrinoviricota	Magsaviricetes	Nodamuvirales			Chrocorelt virus
20774734	20774734	PRJNA293022_P_NODE_35417_length_235_cov_0.946237_g34680_i0	PRJNA293022	35417	235	0.946237	2.22365695	Tobamovirus tabaci	3432891	Viruses	Viruses	394	3.04e-105	NTclustered	gi\|2321498817\|gb\|OL471714.1\|	12242	g34680	i0	97.009	99.4170212765957	234	7	99	0	1	234	5626	5393	Tobacco mosaic virus isolate TMV_BS, complete sequence	blastn	23363	394	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Virgaviridae	Tobamovirus	Tobamovirus tabaci
21461489	21461489	PRJNA293022_P_NODE_52097_length_193_cov_1.430556_g51360_i0	PRJNA293022	52097	193	1.430556	2.76097308	Tobamovirus	12234	Viruses	Viruses	350	5.27e-92	NTclustered	gi\|2201440261\|gb\|OL652662.1\|	12253	g51360	i0	99.479	99.4818652849741	192	1	99	0	1	192	5359	5168	Tomato mosaic virus isolate NVWA36783860, complete genome	blastn	19200	350	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Virgaviridae	Tobamovirus	Tobamovirus tomatotessellati
22049960	22049960	PRJNA293022_P_NODE_77418_length_163_cov_0.912281_g76681_i0	PRJNA293022	77418	163	0.912281	1.48701803	Tobamovirus tabaci	3432891	Viruses	Viruses	292	7.35e-75	NTclustered	gi\|2438595701\|gb\|ON156784.1\|	12242	g76681	i0	99.379	98.7730061349693	161	1	99	0	1	161	3669	3509	Tobacco mosaic virus isolate Ta9, complete genome	blastn	16100	292	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Virgaviridae	Tobamovirus	Tobamovirus tabaci

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