metadata: contig_metadata: 14 rows where bioproject = "PRJNA807836" and tax

14 rows where bioproject = "PRJNA807836" 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
3358203	3358203	PRJNA807836_S_NODE_3_length_3710_cov_4.651361_g2_i0	PRJNA807836	3	3710	4.651361	172.5654931	Carlavirus hydrangeae	3427759	Viruses	Viruses	6259	0	NTclustered	gi\|242346753\|ref\|NC_012869.1\|	375546	g2	i0	97.116	4.58787061994609	3710	107	100	0	1	3710	3066	6775	Hydrangea chlorotic mottle virus, complete genome	blastn	17021	6259	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus hydrangeae
4635638	4635638	PRJNA807836_S_NODE_2804_length_1029_cov_2.810669_g2632_i0	PRJNA807836	2804	1029	2.810669	28.92178401	Carlavirus hydrangeae	3427759	Viruses	Viruses	1751	0	NTclustered	gi\|242346753\|ref\|NC_012869.1\|	375546	g2632	i0	97.376	3.53061224489796	1029	27	100	0	1	1029	1328	300	Hydrangea chlorotic mottle virus, complete genome	blastn	3633	1751	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus hydrangeae
7185263	7185263	PRJNA807836_S_NODE_19266_length_312_cov_6.677824_g18990_i0	PRJNA807836	19266	312	6.677824	20.83481088	Carlavirus hydrangeae	3427759	Viruses	Viruses	544	3.95e-150	NTclustered	gi\|242346753\|ref\|NC_012869.1\|	375546	g18990	i0	99.01	2.91346153846154	303	3	97	0	4	306	324	22	Hydrangea chlorotic mottle virus, complete genome	blastn	909	544	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus hydrangeae
7185671	7185671	PRJNA807836_S_NODE_726_length_1703_cov_5.276687_g672_i0	PRJNA807836	726	1703	5.276687	89.86197961	Carlavirus hydrangeae	3427759	Viruses	Viruses	3070	0	NTclustered	gi\|90592291\|gb\|DQ412999.1\|	375546	g672	i0	99.235	5.11802701115678	1699	11	99	2	6	1703	1752	55	Hydrangea chlorotic mottle virus 12 kDa protein (TGB2) gene, partial cds; and triple gene block protein 3, coat protein (CP), and putative nucleic acid-binding protein genes, complete cds	blastn	8716	3070	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus hydrangeae
12286782	12286782	PRJNA807836_S_NODE_6850_length_617_cov_2.283088_g6590_i0	PRJNA807836	6850	617	2.283088	14.08665296	Carlavirus hydrangeae	3427759	Viruses	Viruses	1026	0	NTclustered	gi\|242346753\|ref\|NC_012869.1\|	375546	g6590	i0	96.748	2.9902755267423	615	20	99	0	3	617	1927	1313	Hydrangea chlorotic mottle virus, complete genome	blastn	1845	1026	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus hydrangeae
13560672	13560672	PRJNA807836_S_NODE_1931_length_1221_cov_3.479094_g1806_i0	PRJNA807836	1931	1221	3.479094	42.47973774	Carlavirus hydrangeae	3427759	Viruses	Viruses	2006	0	NTclustered	gi\|242346753\|ref\|NC_012869.1\|	375546	g1806	i0	96.318	3.001638001638	1222	43	100	2	1	1221	3111	1891	Hydrangea chlorotic mottle virus, complete genome	blastn	3665	2006	1	Viruses	Orthornavirae	Kitrinoviricota	Alsuviricetes	Tymovirales	Betaflexiviridae	Carlavirus	Carlavirus hydrangeae
24174582	24174582	PRJNA807836_S_NODE_22039_length_288_cov_1.632558_g21763_i0	PRJNA807836	22039	288	1.632558	4.70176704	Viruses	10239	Viruses	Viruses	52.8	0.027	NTclustered	gi\|2054396725\|tpg\|BK031138.1\|	2828115	g21763	i0	100	0.315972222222222	28	0	10	0	30	57	58138	58165	MAG TPA_asm: Myoviridae sp. ctfuG5, partial genome	blastn	91	52.8	1	Viruses	Heunggongvirae	Uroviricota	Caudoviricetes				Myoviridae sp. ctfuG5
27496680	27496680	PRJNA807836_S_NODE_24283_length_271_cov_2.181818_g24007_i0	PRJNA807836	24283	271	2.181818	5.91272678	Goldenrod fern yue-like virus	2933170	Viruses	Viruses	139	6.13e-36	NR	CAI5383876.1	2933170	g24007	i0	71.1	0.996309963099631	90	26	99.6	0	2	271	530	619	CAI5383876.1 RNA-dependent RNA polymerase, partial [Goldenrod fern yue-like virus]	diamond	270	139	1	Viruses	Orthornavirae	Negarnaviricota	Yunchangviricetes	Goujianvirales	Yueviridae		Goldenrod fern yue-like virus
28412322	28412322	PRJNA807836_S_NODE_7066_length_605_cov_1.892857_g6805_i0	PRJNA807836	7066	605	1.892857	11.45178485	Indivirus ILV1	1977633	Viruses	Viruses	48.5	0.0075	NR	ARF10000.1	1977633	g6805	i0	27.5	0.862809917355372	120	77	59	4	218	574	138	248	ARF10000.1 serine/threonine protein kinase [Indivirus ILV1]	diamond	522	48.5	1	Viruses	Bamfordvirae	Nucleocytoviricota	Megaviricetes	Imitervirales	Mimiviridae	Indivirus	Indivirus ILV1
28507037	28507037	PRJNA807836_S_NODE_29607_length_245_cov_0.889535_g29331_i0	PRJNA807836	29607	245	0.889535	2.17936075	Rose yellow vein virus	1213588	Viruses	Viruses	60.1	2.97e-8	NR	YP_007761644.1	1213588	g29331	i0	38.8	0.979591836734694	80	47	98	2	5	244	261	338	YP_007761644.1 reverse transcriptase [Rose yellow vein virus]	diamond	240	60.1	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Rosadnavirus	Rosadnavirus venarosae
31634367	31634367	PRJNA807836_S_NODE_6376_length_649_cov_2.092014_g6119_i0	PRJNA807836	6376	649	2.092014	13.57717086	Goldenrod fern yue-like virus	2933170	Viruses	Viruses	226	2.7500000000000003e-64	NR	CAI5383876.1	2933170	g6119	i0	54.8	0.970724191063174	210	87	93.4	2	646	41	882	1091	CAI5383876.1 RNA-dependent RNA polymerase, partial [Goldenrod fern yue-like virus]	diamond	630	226	1	Viruses	Orthornavirae	Negarnaviricota	Yunchangviricetes	Goujianvirales	Yueviridae		Goldenrod fern yue-like virus
32045806	32045806	PRJNA807836_S_NODE_31078_length_241_cov_0.916667_g30802_i0	PRJNA807836	31078	241	0.916667	2.20916747	Goldenrod fern yue-like virus	2933170	Viruses	Viruses	103	1.4599999999999995e-23	NR	CAI5383876.1	2933170	g30802	i0	66.3	0.995850622406639	80	27	99.6	0	1	240	315	394	CAI5383876.1 RNA-dependent RNA polymerase, partial [Goldenrod fern yue-like virus]	diamond	240	103	1	Viruses	Orthornavirae	Negarnaviricota	Yunchangviricetes	Goujianvirales	Yueviridae		Goldenrod fern yue-like virus
32172470	32172470	PRJNA807836_S_NODE_22358_length_286_cov_0.859155_g22082_i0	PRJNA807836	22358	286	0.859155	2.4571833	Viola yellow mottle virus	2922803	Viruses	Viruses	94.7	3.29e-20	NR	UML14526.1	2922803	g22082	i0	51.2	0.881118881118881	84	41	88.1	0	12	263	286	369	UML14526.1 polymerase [Viola yellow mottle virus]	diamond	252	94.7	1	Viruses	Pararnavirae	Artverviricota	Revtraviricetes	Ortervirales	Caulimoviridae	Rosadnavirus	Rosadnavirus maculaviolae
32741077	32741077	PRJNA807836_S_NODE_30180_length_243_cov_1.352941_g29904_i0	PRJNA807836	30180	243	1.352941	3.28764663	Goldenrod fern yue-like virus	2933170	Viruses	Viruses	140	1.66e-36	NR	CAI5383876.1	2933170	g29904	i0	80.2	1	81	16	100	0	243	1	794	874	CAI5383876.1 RNA-dependent RNA polymerase, partial [Goldenrod fern yue-like virus]	diamond	243	140	1	Viruses	Orthornavirae	Negarnaviricota	Yunchangviricetes	Goujianvirales	Yueviridae		Goldenrod fern yue-like virus

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