RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJDB14275" and tax_kingdom = "Shotokuvirae"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

  • Shotokuvirae · 6 ✖

tax_clade 1

bioproject 1

  • PRJDB14275 · 6 ✖
Link rowid ▼ query bioproject node length coverage rel_abundance taxname_lca taxid_lca taxoncategory taxoncategorysimple bits evalue lowcoverage_flag 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_clade tax_kingdom tax_phylum tax_class tax_order tax_family tax_genus tax_species
18832835 18832835 PRJDB14275_P_NODE_4775_length_235_cov_1.346939_g4716_i0 PRJDB14275 4775 235 1.346939 3.1653066500000002 Viruses 10239 Viruses Viruses 399 6.529999999999999e-107   NTclustered gi|1848664582|gb|MN891788.1| 2740165 g4716 i0 100 2.75744680851064 216 0 92 0 1 216 2415 2200 Brassica caulorapa CRESS virus strain pt079-cirl-1, complete genome blastn 648 399 1 Viruses CRESS viruses Shotokuvirae Cressdnaviricota         Brassica caulorapa CRESS virus
20409201 20409201 PRJDB14275_P_NODE_2337_length_441_cov_4.303483_g2278_i0 PRJDB14275 2337 441 4.303483 18.97836003 Tick-associated circular virus-2 2951484 Viruses Viruses 784 0   NTclustered gi|2263979286|gb|ON456885.1| 2951484 g2278 i0 99.535 0.975056689342404 430 2 98 0 12 441 1694 2123 Tick-associated circular virus-2 isolate Tick114CressC5, complete genome blastn 430 784 1 Viruses   Shotokuvirae Cressdnaviricota Arfiviricetes Cirlivirales Circoviridae   Tick-associated circular virus-2
20409203 20409203 PRJDB14275_P_NODE_2517_length_416_cov_5.405836_g2458_i0 PRJDB14275 2517 416 5.405836 22.48827776 Reagent-associated CRESS-like virus 4 2875812 Viruses Viruses 634 3.1199999999999998e-177   NTclustered gi|2094552985|gb|MZ824234.1| 2875812 g2458 i0 99.711 0.831730769230769 346 1 83 0 71 416 2663 2318 Reagent-associated CRESS-like virus 4 isolate 10 replicase-like gene, partial sequence blastn 346 634 1 Viruses   Shotokuvirae Cressdnaviricota         Reagent-associated CRESS-like virus 4
23933517 23933517 PRJDB14275_P_NODE_4199_length_263_cov_2.183036_g4140_i0 PRJDB14275 4199 263 2.183036 5.74138468 Viruses 10239 Viruses Viruses 451 2.03e-122   NTclustered gi|1848664582|gb|MN891788.1| 2740165 g4140 i0 99.595 2.82889733840304 247 1 94 0 1 247 85 331 Brassica caulorapa CRESS virus strain pt079-cirl-1, complete genome blastn 744 451 1 Viruses CRESS viruses Shotokuvirae Cressdnaviricota         Brassica caulorapa CRESS virus
24234436 24234436 PRJDB14275_P_NODE_1060_length_739_cov_20.174286_g1012_i0 PRJDB14275 1060 739 20.174286 149.08797354 Reagent-associated CRESS-like virus 6 2875814 Viruses Viruses 1339 0   NTclustered gi|2094552983|gb|MZ824232.1| 2875814 g1012 i0 100 0.98105548037889 725 0 98 0 1 725 1135 411 Reagent-associated CRESS-like virus 6 isolate 12 replicase-like gene, partial sequence blastn 725 1339 1 Viruses   Shotokuvirae Cressdnaviricota         Reagent-associated CRESS-like virus 6
31075162 31075162 PRJDB14275_P_NODE_6715_length_175_cov_1.235294_g6656_i0 PRJDB14275 6715 175 1.235294 2.1617645 Ciconia boyciana CRESS-DNA-virus sp. 2815024 Viruses Viruses 48.5 1.3e-4   NR QTE03332.1 2815024 g6656 i0 46.5 2.14285714285714 43 23 73.7 0 160 32 52 94 QTE03332.1 MAG: replication-associated protein [Ciconia boyciana CRESS-DNA-virus sp.] diamond 375 48.5 1 Viruses   Shotokuvirae Cressdnaviricota         Ciconia boyciana CRESS-DNA-virus sp.

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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