RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJEB28062" and tax_phylum = "Chlorobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chlorobiota · 20 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB28062 · 20 ✖

analysis 1

  • diamond · 20 ✖
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
2574825 2574825 PRJEB28062_P_NODE_50443_length_502_cov_2.713287_g48094_i0 PRJEB28062 50443 502 2.713287 13.62070074 Chlorobi bacterium NICIL-2 1662223 Bacteria Bacteria 160 7.6e-43   NR KXB96971.1 1662223 g48094 i0 91 0.531872509960159 89 8 53.2 0 484 218 47 135 KXB96971.1 MAG: hypothetical protein AA908_09315 [Chlorobi bacterium NICIL-2] diamond 267 160 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobi bacterium NICIL-2
12778490 12778490 PRJEB28062_P_NODE_50031_length_504_cov_8.849188_g47682_i0 PRJEB28062 50031 504 8.849188 44.59990752 Chlorobi bacterium NICIL-2 1662223 Bacteria Bacteria 196 1.1499999999999999e-60   NR KXB98239.1 1662223 g47682 i0 98 0.589285714285714 99 2 58.9 0 13 309 90 188 KXB98239.1 MAG: hypothetical protein AA908_02255 [Chlorobi bacterium NICIL-2] diamond 297 196 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobi bacterium NICIL-2
14053420 14053420 PRJEB28062_P_NODE_65632_length_428_cov_3.219718_g63271_i0 PRJEB28062 65632 428 3.219718 13.78039304 Pseudomonadati 3379134 Bacteria Bacteria 188 1.6499999999999996e-55   NR WP_131354818.1 2491138 g63271 i0 77.7 11.7827102803738 112 25 78.5 0 341 6 137 248 WP_131354818.1 ATP-binding protein [Chlorobium sp. N1] diamond 5043 188 1 Bacteria FCB group Pseudomonadati Chlorobiota Chlorobiia Chlorobiales Chlorobiaceae Chlorobium Chlorobium sp. N1
27096358 27096358 PRJEB28062_P_NODE_37322_length_598_cov_12.175238_g34995_i0 PRJEB28062 37322 598 12.175238 72.80792324 Chlorobiota bacterium 2268192 Bacteria Bacteria 325 1.5899999999999996e-106   NR RMF36114.1 2268192 g34995 i0 94.8 1.74080267558528 172 9 86.3 0 68 583 183 354 RMF36114.1 MAG: ATP-binding protein [Chlorobiota bacterium] diamond 1041 325 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobiota bacterium
27570254 27570254 PRJEB28062_P_NODE_108004_length_292_cov_1.214612_g105641_i0 PRJEB28062 108004 292 1.214612 3.54666704 Chlorobi bacterium NICIL-2 1662223 Bacteria Bacteria 171 1.66e-48   NR KXB97229.1 1662223 g105641 i0 97.8 0.914383561643836 89 2 91.4 0 269 3 195 283 KXB97229.1 MAG: hypothetical protein AA908_07955 [Chlorobi bacterium NICIL-2] diamond 267 171 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobi bacterium NICIL-2
27854461 27854461 PRJEB28062_P_NODE_29585_length_678_cov_62.204959_g27302_i0 PRJEB28062 29585 678 62.204959 421.74962202 Chlorobi bacterium NICIL-2 1662223 Bacteria Bacteria 253 1.31e-78   NR KXB98131.1 1662223 g27302 i0 88.4 0.685840707964602 155 18 68.6 0 489 25 81 235 KXB98131.1 MAG: hypothetical protein AA908_01640 [Chlorobi bacterium NICIL-2] diamond 465 253 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobi bacterium NICIL-2
28043979 28043979 PRJEB28062_P_NODE_85485_length_359_cov_16.912587_g83123_i0 PRJEB28062 85485 359 16.912587 60.71618733 Chlorobi bacterium NICIL-2 1662223 Bacteria Bacteria 157 4.249999999999999e-43   NR KXB97622.1 1662223 g83123 i0 92.9 1.42061281337047 85 6 71 0 314 60 299 383 KXB97622.1 MAG: hypothetical protein AA908_05725 [Chlorobi bacterium NICIL-2] diamond 510 157 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobi bacterium NICIL-2
28075418 28075418 PRJEB28062_P_NODE_36425_length_606_cov_46.771107_g34100_i0 PRJEB28062 36425 606 46.771107 283.43290842 Chlorobi bacterium NICIL-2 1662223 Bacteria Bacteria 386 3.689999999999999e-121   NR KXB98639.1 1662223 g34100 i0 97.9 0.945544554455445 191 4 94.6 0 592 20 592 782 KXB98639.1 MAG: hypothetical protein AA908_04470 [Chlorobi bacterium NICIL-2] diamond 573 386 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobi bacterium NICIL-2
28226648 28226648 PRJEB28062_P_NODE_53466_length_484_cov_71.126521_g51113_i0 PRJEB28062 53466 484 71.126521 344.25236164 Pseudomonadati 3379134 Bacteria Bacteria 151 4.82e-39   NR RMF33596.1 2268192 g51113 i0 84.5 1.56198347107438 84 13 52.1 0 11 262 576 659 RMF33596.1 MAG: hypothetical protein D6747_06570, partial [Chlorobiota bacterium] diamond 756 152 0.993421052631579 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobiota bacterium
28359548 28359548 PRJEB28062_P_NODE_52766_length_488_cov_11.857831_g50413_i0 PRJEB28062 52766 488 11.857831 57.86621528 Chlorobi bacterium NICIL-2 1662223 Bacteria Bacteria 274 1.34e-85   NR KXB97808.1 1662223 g50413 i0 99.2 0.817622950819672 133 1 81.8 0 69 467 183 315 KXB97808.1 MAG: hypothetical protein AA908_05235 [Chlorobi bacterium NICIL-2] diamond 399 274 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobi bacterium NICIL-2
29432877 29432877 PRJEB28062_P_NODE_124150_length_251_cov_1.702247_g121786_i0 PRJEB28062 124150 251 1.702247 4.27263997 Chlorobi bacterium NICIL-2 1662223 Bacteria Bacteria 149 2.849999999999999e-41   NR KXB97035.1 1662223 g121786 i0 95.1 0.968127490039841 81 4 96.8 0 1 243 57 137 KXB97035.1 MAG: hypothetical protein AA908_08825 [Chlorobi bacterium NICIL-2] diamond 243 149 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobi bacterium NICIL-2
29843671 29843671 PRJEB28062_P_NODE_34331_length_626_cov_8.504521_g32016_i0 PRJEB28062 34331 626 8.504521 53.23830146 Chlorobi bacterium NICIL-2 1662223 Bacteria Bacteria 228 7.19e-65   NR KXB97433.1 1662223 g32016 i0 100 0.541533546325879 113 0 54.2 0 266 604 927 1039 KXB97433.1 MAG: DEAD/DEAH box helicase [Chlorobi bacterium NICIL-2] diamond 339 228 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobi bacterium NICIL-2
30633338 30633338 PRJEB28062_P_NODE_51833_length_493_cov_37.783333_g49482_i0 PRJEB28062 51833 493 37.783333 186.27183169 Chlorobi bacterium NICIL-2 1662223 Bacteria Bacteria 313 5.029999999999999e-101   NR KXB98523.1 1662223 g49482 i0 92.5 1.947261663286 160 12 97.4 0 482 3 177 336 KXB98523.1 MAG: nitrous oxide reductase [Chlorobi bacterium NICIL-2] diamond 960 313 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobi bacterium NICIL-2
31012682 31012682 PRJEB28062_P_NODE_88035_length_351_cov_4.446043_g85673_i0 PRJEB28062 88035 351 4.446043 15.60561093 Chlorobi bacterium NICIL-2 1662223 Bacteria Bacteria 88.6 4.63e-18   NR KXB97493.1 1662223 g85673 i0 86.5 0.444444444444444 52 7 44.4 0 195 350 1 52 KXB97493.1 MAG: hypothetical protein AA908_06450 [Chlorobi bacterium NICIL-2] diamond 156 88.6 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobi bacterium NICIL-2
31290549 31290549 PRJEB28062_P_NODE_14255_length_1013_cov_64.867021_g12414_i0 PRJEB28062 14255 1013 64.867021 657.10292273 Bacteria 2 Bacteria Bacteria 620 2.729999999999999e-210   NR KXB97445.1 1662223 g12414 i0 94.9 3.94471865745311 333 17 98.6 0 7 1005 623 955 KXB97445.1 MAG: hypothetical protein AA908_06190 [Chlorobi bacterium NICIL-2] diamond 3996 620 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobi bacterium NICIL-2
31297088 31297088 PRJEB28062_P_NODE_22015_length_797_cov_9.062155_g19864_i0 PRJEB28062 22015 797 9.062155 72.22537535 Chlorobi bacterium NICIL-2 1662223 Bacteria Bacteria 281 9.07e-93   NR KXB97019.1 1662223 g19864 i0 81.9 1.24968632371393 166 30 62.5 0 5 502 12 177 KXB97019.1 MAG: hypothetical protein AA908_08735 [Chlorobi bacterium NICIL-2] diamond 996 281 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobi bacterium NICIL-2
32625452 32625452 PRJEB28062_P_NODE_66300_length_425_cov_14.045455_g63939_i0 PRJEB28062 66300 425 14.045455 59.69318375 Chlorobi bacterium NICIL-2 1662223 Bacteria Bacteria 135 2.18e-36   NR KXB97624.1 1662223 g63939 i0 98.5 0.48 68 1 48 0 361 158 174 241 KXB97624.1 MAG: hypothetical protein AA908_05735 [Chlorobi bacterium NICIL-2] diamond 204 135 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobi bacterium NICIL-2
32625467 32625467 PRJEB28062_P_NODE_86240_length_357_cov_4.767606_g83878_i0 PRJEB28062 86240 357 4.767606 17.02035342 Chlorobi bacterium NICIL-2 1662223 Bacteria Bacteria 201 5.12e-57   NR KXB97180.1 1662223 g83878 i0 98 0.848739495798319 101 2 84.9 0 32 334 980 1080 KXB97180.1 MAG: hypothetical protein AA908_08475 [Chlorobi bacterium NICIL-2] diamond 303 201 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobi bacterium NICIL-2
32751484 32751484 PRJEB28062_P_NODE_34180_length_627_cov_67.274368_g31865_i0 PRJEB28062 34180 627 67.274368 421.81028736 Chlorobi bacterium NICIL-2 1662223 Bacteria Bacteria 346 1.3499999999999998e-109   NR KXB98098.1 1662223 g31865 i0 94.9 0.937799043062201 196 10 93.8 0 19 606 463 658 KXB98098.1 MAG: hypothetical protein AA908_01445 [Chlorobi bacterium NICIL-2] diamond 588 346 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobi bacterium NICIL-2
32782826 32782826 PRJEB28062_P_NODE_42800_length_552_cov_36.162839_g40464_i0 PRJEB28062 42800 552 36.162839 199.61887128 Chlorobi bacterium NICIL-2 1662223 Bacteria Bacteria 288 1.88e-89   NR KXB97794.1 1662223 g40464 i0 99.3 0.809782608695652 149 1 81 0 470 24 194 342 KXB97794.1 MAG: hypothetical protein AA908_05165 [Chlorobi bacterium NICIL-2] diamond 447 288 1 Bacteria FCB group Pseudomonadati Chlorobiota         Chlorobi bacterium NICIL-2

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