metadata: contig_metadata: 17 rows where bioproject = "PRJNA597223" and tax

17 rows where bioproject = "PRJNA597223" and tax_phylum = "Kitrinoviricota"

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
1844758	1844758	PRJNA597223_P_NODE_42142_length_219_cov_1.798913_g40296_i0	PRJNA597223	42142	219	1.798913	3.93961947	Jujube closterovirus 1	3043313	Viruses	Viruses	52.8	0.019	NTclustered	gi\|2496749738\|gb\|OP673405.1\|	3043313	g40296	i0	100	0.127853881278539	28	0	13	0	1	28	11	38	Jujube closterovirus 1 isolate AKS15-20, complete genome	blastn	28	52.8	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Closteroviridae		Jujube closterovirus 1
1844928	1844928	PRJNA597223_P_NODE_56102_length_188_cov_2.294118_g54256_i0	PRJNA597223	56102	188	2.294118	4.31294184	Bromovirus BMV	3427622	Viruses	Viruses	135	1.5600000000000002e-27	NTclustered	gi\|107015847\|gb\|DQ530424.1\|	12302	g54256	i0	100	19.3670212765957	73	0	78	0	5	77	679	751	Brome mosaic virus strain Fescue segment RNA2, complete sequence	blastn	3641	135	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Martellivirales	Bromoviridae	Bromovirus	Bromovirus BMV
1845023	1845023	PRJNA597223_P_NODE_66362_length_177_cov_1.021127_g64516_i0	PRJNA597223	66362	177	1.021127	1.80739479	Potexvirus pepini	3433856	Viruses	Viruses	322	1.03e-83	NTclustered	gi\|384872954\|gb\|JQ314458.1\|	112229	g64516	i0	99.435	62.7683615819209	177	1	100	0	1	177	5452	5276	Pepino mosaic virus strain US1_CAHN8, complete genome	blastn	11110	322	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Potexvirus	Potexvirus pepini
1845233	1845233	PRJNA597223_P_NODE_82942_length_154_cov_3.327731_g81096_i0	PRJNA597223	82942	154	3.327731	5.12470574	Potexvirus pepini	3433856	Viruses	Viruses	243	6.99e-60	NTclustered	gi\|1540839163\|gb\|MK133094.1\|	112229	g81096	i0	95.513	53.7142857142857	156	0	97	1	6	154	2932	3087	Pepino mosaic virus isolate PepMV-P12-3H, complete genome	blastn	8272	243	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Potexvirus	Potexvirus pepini
2416141	2416141	PRJNA597223_P_NODE_70942_length_169_cov_2.059701_g69096_i0	PRJNA597223	70942	169	2.059701	3.48089469	root	1	Root_unresolved	Root_unresolved	309	7.58e-80	NTclustered	gi\|428754724\|gb\|JX866621.1\|	112229	g69096	i0	100	23.698224852071	167	0	99	0	2	168	310	144	Pepino mosaic virus isolate BNMX12-03 coat protein gene, complete cds	blastn	4005	309	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Potexvirus	Potexvirus pepini
4968834	4968834	PRJNA597223_P_NODE_4_length_6520_cov_10.920740_g2_i0	PRJNA597223	4	6520	10.92074	712.032248	Maculavirus	249185	Viruses	Viruses	11324	0	NTclustered	gi\|612507560\|gb\|KJ433990.1\|	288456	g2	i0	98.036	4.87883435582822	6517	127	99	1	1	6516	6526	10	Bombyx mori Macula-like virus strain SZ, complete genome	blastn	31810	11433	0.99046619434969	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Tymoviridae	Maculavirus	Bombyx mori Macula-like virus
6947797	6947797	PRJNA597223_P_NODE_82226_length_155_cov_2.183333_g80380_i0	PRJNA597223	82226	155	2.183333	3.38416615	Alphanodavirus flockense	3426214	Viruses	Viruses	279	5.37e-71	NTclustered	gi\|351066204\|gb\|JF461542.1\|	12287	g80380	i0	100	6.79354838709677	151	0	97	0	5	155	984	1134	Flock house virus isolate IP-VIA-022011 coat protein precursor, gene, complete cds	blastn	1053	279	1	Viruses	Orthornavirae	Kitrinoviricota	Magsaviricetes	Nodamuvirales	Nodaviridae	Alphanodavirus	Alphanodavirus flockense
10069414	10069414	PRJNA597223_P_NODE_76148_length_162_cov_2.228346_g74302_i0	PRJNA597223	76148	162	2.228346	3.60992052	root	1	Root_unresolved	Root_unresolved	289	9.44e-74	NTclustered	gi\|209418808\|gb\|EU797176.1\|	112229	g74302	i0	98.765	30.9814814814815	162	2	100	0	1	162	638	477	Pepino mosaic virus isolate PepMV-Can1 coat protein (CP) gene, partial cds	blastn	5019	289	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Potexvirus	Potexvirus pepini
12048141	12048141	PRJNA597223_P_NODE_33010_length_257_cov_2.527027_g31164_i0	PRJNA597223	33010	257	2.527027	6.49445939	Alphanodavirus flockense	3426214	Viruses	Viruses	451	1.97e-122	NTclustered	gi\|351066201\|gb\|JF461541.1\|	12287	g31164	i0	98.819	13.8015564202335	254	2	98	1	1	253	2322	2069	Flock house virus isolate IP-VIA-022011 segment RNA1, complete sequence	blastn	3547	451	1	Viruses	Orthornavirae	Kitrinoviricota	Magsaviricetes	Nodamuvirales	Nodaviridae	Alphanodavirus	Alphanodavirus flockense
12048349	12048349	PRJNA597223_P_NODE_49130_length_199_cov_2.737805_g47284_i0	PRJNA597223	49130	199	2.737805	5.44823195	Alphanodavirus flockense	3426214	Viruses	Viruses	233	5.75e-57	NTclustered	gi\|351066201\|gb\|JF461541.1\|	12287	g47284	i0	100	31.7939698492462	126	0	97	0	2	127	2851	2726	Flock house virus isolate IP-VIA-022011 segment RNA1, complete sequence	blastn	6327	233	1	Viruses	Orthornavirae	Kitrinoviricota	Magsaviricetes	Nodamuvirales	Nodaviridae	Alphanodavirus	Alphanodavirus flockense
14598068	14598068	PRJNA597223_P_NODE_49132_length_199_cov_2.713415_g47286_i0	PRJNA597223	49132	199	2.713415	5.39969585	Alphanodavirus flockense	3426214	Viruses	Viruses	366	5.43e-97	NTclustered	gi\|351066201\|gb\|JF461541.1\|	12287	g47286	i0	100	23.070351758794	198	0	99	0	1	198	1877	2074	Flock house virus isolate IP-VIA-022011 segment RNA1, complete sequence	blastn	4591	366	1	Viruses	Orthornavirae	Kitrinoviricota	Magsaviricetes	Nodamuvirales	Nodaviridae	Alphanodavirus	Alphanodavirus flockense
15872220	15872220	PRJNA597223_P_NODE_81533_length_156_cov_1.586777_g79687_i0	PRJNA597223	81533	156	1.586777	2.47537212	Alphanodavirus flockense	3426214	Viruses	Viruses	274	2.52e-69	NTclustered	gi\|262225309\|gb\|GQ342965.1\|	663279	g79687	i0	98.701	12.7692307692308	154	2	99	0	1	154	1593	1746	Drosophila melanogaster American nodavirus (ANV) SW-2009a segment RNA1, complete sequence	blastn	1992	274	1	Viruses	Orthornavirae	Kitrinoviricota	Magsaviricetes	Nodamuvirales	Nodaviridae	Alphanodavirus	Alphanodavirus flockense
15872226	15872226	PRJNA597223_P_NODE_82333_length_155_cov_1.850000_g80487_i0	PRJNA597223	82333	155	1.85	2.8675	Potexvirus pepini	3433856	Viruses	Viruses	285	1.15e-72	NTclustered	gi\|375808845\|gb\|JN835466.1\|	112229	g80487	i0	100	57.5677419354839	154	0	99	0	2	155	275	122	Pepino mosaic virus strain CH2, complete genome	blastn	8923	285	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Potexvirus	Potexvirus pepini
17718584	17718584	PRJNA597223_P_NODE_53074_length_191_cov_2.006410_g51228_i0	PRJNA597223	53074	191	2.00641	3.8322431	Potexvirus	12176	Viruses	Viruses	350	5.2000000000000014e-92	NTclustered	gi\|1421680722\|gb\|MH550248.1\|	112229	g51228	i0	100	98.9371727748691	189	0	99	0	1	189	709	897	Pepino mosaic virus isolate GR17-4a TGBp1, TGBp2, TGBp3, and CP genes, complete cds	blastn	18897	350	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Potexvirus	Potexvirus pepini
20971599	20971599	PRJNA597223_P_NODE_6497_length_683_cov_13.382716_g5103_i0	PRJNA597223	6497	683	13.382716	91.40395028	Alphanodavirus flockense	3426214	Viruses	Viruses	324	1.31e-83	NTclustered	gi\|262225312\|gb\|GQ342966.1\|	663279	g5103	i0	96.429	5.88286969253294	196	7	73	0	176	371	712	517	Drosophila melanogaster American nodavirus (ANV) SW-2009a segment RNA2, complete sequence	blastn	4018	324	1	Viruses	Orthornavirae	Kitrinoviricota	Magsaviricetes	Nodamuvirales	Nodaviridae	Alphanodavirus	Alphanodavirus flockense
23521220	23521220	PRJNA597223_P_NODE_18219_length_384_cov_1.699140_g16396_i0	PRJNA597223	18219	384	1.69914	6.5246976	Alphanodavirus flockense	3426214	Viruses	Viruses	682	0	NTclustered	gi\|351066201\|gb\|JF461541.1\|	12287	g16396	i0	99.206	39.390625	378	3	98	0	2	379	1315	938	Flock house virus isolate IP-VIA-022011 segment RNA1, complete sequence	blastn	15126	682	1	Viruses	Orthornavirae	Kitrinoviricota	Magsaviricetes	Nodamuvirales	Nodaviridae	Alphanodavirus	Alphanodavirus flockense
24795565	24795565	PRJNA597223_P_NODE_74760_length_164_cov_1.581395_g72914_i0	PRJNA597223	74760	164	1.581395	2.5934878	Potexvirus pepini	3433856	Viruses	Viruses	298	1.59e-76	NTclustered	gi\|1861598093\|gb\|MN549397.1\|	112229	g72914	i0	99.39	12	164	1	100	0	1	164	1896	1733	Pepino mosaic virus isolate Ca1A, complete genome	blastn	1968	298	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Alphaflexiviridae	Potexvirus	Potexvirus pepini

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